G Guest Aug 31, 2006 #1 Howe dio I format a cell in excel 2003 sop when th enumber 2 is entered, it shows it as 0002?
M MyVeryOwnSelf Aug 31, 2006 #2 How do I format a cell in excel 2003 sop when the number 2 is entered, it shows it as 0002? Click to expand... One way is to use: Format > Cells > Number > Custom and to put 0000 as the "Type".
How do I format a cell in excel 2003 sop when the number 2 is entered, it shows it as 0002? Click to expand... One way is to use: Format > Cells > Number > Custom and to put 0000 as the "Type".
G Guest Aug 31, 2006 #3 Format... Cells... Number Tab... Select Custom from category. Enter 0000 in the Type: blank. Once you have done this once, it will be menu selection under they type entry box.
Format... Cells... Number Tab... Select Custom from category. Enter 0000 in the Type: blank. Once you have done this once, it will be menu selection under they type entry box.
