excel format

[LOLLOBRIDGE]

Hi all,
i'm writing a number in a cell but this number has one or more zero at the beginning, ex. 01113425.
Someone could tell me how to format the cell (custom , not text please)?

i've the same problem with access.

Thanks a lot!

 

[Richard Schollar]

Are the numbers always the same number of digits ie so always 6 digits long so that if you have 123 it therefore needs 3 leading zeros to bring it up to the 6 digits? Then you can use:

000000

as the custom format.

 

[barry houdini]

If your number always has 8 digits (including any leading zeroes) then try a custom format of

00000000

 

[LOLLOBRIDGE]

Great!!!
it works for excel and access as well.
Thk u both