If you always want 5 digits (with as many leading zeros as it takes), you could
use a custom format of:

00000
(Format|cells|Number tab)

You can use as many 0's as you want.


Gmonny wrote:

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?

--

Dave Peterson