Hi,

custom format as "0"0.00

note, the figures will appear as 01234 but on the formula bar you will see
1234.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Gmonny" escreveu:

I'm trying to use a numeric value with a leading zero, but the format keeps
dropping the leading zero. I've tried custom formatting, but it also drops
the lead zero. The only way to display the leading zero is to format the
value to text, but then it places the text tag in the cell, which I don't
want. Is there a way to format a cell to allow leading zeros without
converting or formatting the value as text?