G Guest Nov 17, 2004 #1 How can I insert a number leading off with a 0 into a cell that is formatted as general without the 0 getting kicked?
How can I insert a number leading off with a 0 into a cell that is formatted as general without the 0 getting kicked?
G Guest Nov 17, 2004 #2 hi, 1.format it as text(recommended) 2.custom format 00000 (or how every many characters you need)
J JE McGimpsey Nov 17, 2004 #3 If you need to use the number in subsequent calculations, choose Format/Cells/Number/Custom, and either choose the number of digits you want, e.g., 0000;-0000;0000 or the number of leading zero's you want, e.g., "00"0;"-00"0;"000" If the number doesn't need to be used in calculations, either preformat the cell as Text, or prefix the entry with an apostrophe, e.g., '0000
If you need to use the number in subsequent calculations, choose Format/Cells/Number/Custom, and either choose the number of digits you want, e.g., 0000;-0000;0000 or the number of leading zero's you want, e.g., "00"0;"-00"0;"000" If the number doesn't need to be used in calculations, either preformat the cell as Text, or prefix the entry with an apostrophe, e.g., '0000
