leading zeros when uploading a number from text file

M

mc01234

I view and upload text files with a column of values that contain leading
zeros. I want to retain the leading zeros when I use Excel to view or store
this data. Any suggestions on how to turn off, Excel's elimination of the
leading zeros?
 

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

Replacing cell numbers but leaving leading zero 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
How to stop Excel from automatically truncating leading zeros 2
Leading Zero 11
Need 7 digit number with differnt number of leading zeros 10
Lead Zeros in Text 6
REPLACE command drops leading zeros 4
Remove leading zeros 9

Top