View Single Post
  #1   Report Post  
Jenn
 
Posts: n/a
Default Adding Leading Zeros to Text

In column A I have text like the following
1.2
01.34
03.4
2.1

What I need excel to do is look in Column A and any text that does not begin
with a zero character, add a zero to the beginning of the text string, else
leave it alone. So that my above example when done would look like:

01.2
01.34
03.4
02.1

Any quick fixes for this? I have a thousand rows so doing this by hand would
really stink!
Thanks in advance!