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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep Lead Zeros 6
How do I stop Excel from dropping leading zeros? 9
How to stop Excel from automatically truncating leading zeros 2
Display leading zeros in numeric value without converting to text 4
leading zeros are not showing in the formula bar but do show in ce 2
Lead Zeros in Text 6
Add Leading Zeros 4
Converting xls to CSV file - dropping leading 0s 1

Top