Another replace question

[Greg Rivet]

I have a list of numbers, always three digit, all starting with 1 such as:
101, 103, 102 ,100. In a search and replace, I want to remove the 1. In
other words find 101 and repalce with 01 etc. These are actually text
strings that look like numbers. How should the "replace with" be input. TIA

Greg

 

[Max]

Assume the list is in col A, A2 down

Put in say B2: =SUBSTITUTE(A2,1,,1)
Copy B2 down col B

 

[Don Guillett]

how about subtracting 100 from each number by putting 100 in a
cell>copy>select the range to chg>paste>subtract

 

[Guest]

How about this solution. Highlight the list. Go to Format > Cells > Number Tab > Custom. In the Type field, type "0###".