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