Adding Leading Zeros to Text

This formula did it for me:
=TEXT(VALUE(A1),"00.00")

Working from the inside out, this formula converts your text to a value
to standardize each entry so it does not have a leading zero. Then the
formula converts it back to text in 00.00 format- this to accommodate
the 2 decimal places required as in the 01.34 example.

Thanks! Both worked like a charm!

"Dave O" wrote:

> This formula did it for me:
> =TEXT(VALUE(A1),"00.00")
>
> Working from the inside out, this formula converts your text to a value
> to standardize each entry so it does not have a leading zero. Then the
> formula converts it back to text in 00.00 format- this to accommodate
> the 2 decimal places required as in the 01.34 example.
>
>