sorry, meant custom format not formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jenn" <Jenn@discussions.microsoft.com> wrote in message
news:0CF83E0C-5BA9-4694-AF79-B8DF110AD110@microsoft.com...
> 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!
>
>