Why don't you just format the column as a Text Format and enter in the zero
as part of the data entry. Formatting a number only changes the appearance
of the number, not its actual value.


--
Kevin Backmann


"cj21" wrote:


I have a list of products e.g

Product
123
1453
14547
23
234

I want a zero to go at the begiining of each product e.g

Product
0123
01453
014547
023
0234

I have done this through the format option then custom 0#######

However looking at the display in the top to the right of the fx sign
the numbers don't have there zeros is it possible to make them keep
there zero's.

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=527565