View Full Version : real numbers

26-03-2003, 10:04 PM
I need to include the number 0002765432 in a column of 30000 numbers. It must appear exactly as I have written it. I can't put a ' in front of it as it is then recognized as text, not a number. If I reconvert to a number, it drops the zeroes of the front
Can anyone tell me how to put a number starting with zero into an excel column

26-03-2003, 10:16 PM
Format the cell as custom. In the 'type' box put 0000000000 (10 zeros)

27-03-2003, 08:10 AM
Yes, that will do it.
# means put a number if there is a number.
0 means put a number even if there isn't - so you get fixed length.

27-03-2003, 11:06 AM
What you do depends really on how you want to do your overall formatting.
If you literally want ten digits then by all means do the custom format 0000000000

Alternatively, if you are wanting 0002765432 as some number (eg 2765432, or 25 or whatever) with three zeros in front you can use the custom format "000"0

or etc etc

Graham L
27-03-2003, 01:54 PM
PICTURE 9999999999 was the COBOL way wasn't it? :D