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 procedu "0"#. This will put zeros in the cells, but
when I look in the formula bar, the zero is omitted.

Any ideas?

Randy


--
araki
------------------------------------------------------------------------
araki's Profile: http://www.excelforum.com/member.php...o&userid=15334
View this thread: http://www.excelforum.com/showthread...hreadid=373312

Hi Araki,

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

dolphinv4

"araki" wrote:


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 procedu "0"#. This will put zeros in the cells, but
when I look in the formula bar, the zero is omitted.

Any ideas?

Randy


--
araki
------------------------------------------------------------------------
araki's Profile: http://www.excelforum.com/member.php...o&userid=15334
View this thread: http://www.excelforum.com/showthread...hreadid=373312

format the number as text,that will let you have a preceding 0
--
paul
remove nospam for email addy!



"Dolphinv4" wrote:

Hi Araki,

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

dolphinv4

"araki" wrote:


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 procedu "0"#. This will put zeros in the cells, but
when I look in the formula bar, the zero is omitted.

Any ideas?

Randy


--
araki
------------------------------------------------------------------------
araki's Profile: http://www.excelforum.com/member.php...o&userid=15334
View this thread: http://www.excelforum.com/showthread...hreadid=373312