Excel drops my lead zeros: need 0051 not 51

C

Chip Pearson

Format the cell as Text prior to entering the data, or precede the number
with an apostrophe (the apostrophe will not display in the cell but will be
visible in the formula bar) or format the cells with a custom format of
0000.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
P

Peo Sjoblom

Custom format 0000 or preformat as text and AFTER you have formatted as text
type 0051

--


Regards,


Peo Sjoblom
 
D

David Biddulph

Either format as text before you type the number in, or
Precede the number by an apostrophe, or
Format the cell as 0000 if you want a 4 digit number.
 
Top