How about adding a formula of 00.0#?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Jenn" wrote in message
...
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!
|