On Wed, 29 Mar 2006 07:36:41 -0600, 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.


No, not if you want to store them as "numbers". In the display next to the Fx
sign is the actual contents of the cell. Formatting does not apply here.

You would have to convert them to TEXT in order to have that location appear
the way you describe.
--ron