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?

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?

You do not say how many digits you have or what custom formula you tried
I used "0"General as my custom formula to get displays such a 01, 012, 0123,
etc
I did not even have to type the zero
And the values are numeric in that =3*A1 gives 03 when A1 =3 (the format
goes with it as often happens with simple formulas)
Any use?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gmonny" wrote in message
...
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?

Thanks for the reply, Marcelo. I tried that, but the cell still drops the
zero. It doesn't seem to even recognize the format.

"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?

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