Custom Format Cells

[araki]

Hi all,
I am trying to format a numeric cell. I have a number that is numeric,
but I want to add a zero at the beginning of the number. I use the
custom format procedure: "0"#. This will put zeros in the cells, but
when I look in the formula bar, the zero is omitted.

Any ideas?

Randy

 

[Guest]

Hi Araki,

put a " ' " (inverted comma) before you enter "0".

dolphinv4

 

[Guest]

format the number as text,that will let you have a preceding 0