i want to be able to key in numbers with zero in front without excel dropping zeros.
B blu Mar 23, 2006 #1 i want to be able to key in numbers with zero in front without excel dropping zeros.
P Peo Sjoblom Mar 23, 2006 #2 Format as text, or precede entry with an apostrophe or use a custom format 0000 (for 4 digits always showing), the last assumes you always have the same number of digits
Format as text, or precede entry with an apostrophe or use a custom format 0000 (for 4 digits always showing), the last assumes you always have the same number of digits
