Show leading zeros (eg: 000123)

M

Mike C

When I import a file that originally had numbers such as "000123" in
excel, the number only shows 123. Is there a way for me to get the
cell to show 000123?

Thanks
 
D

Dave Peterson

Another option:

If you're importing the data from a text file that is named *.csv (comma
separated values), then try renaming the file to *.txt.

When you use file|open, you'll see a data import wizard where you can specify
the type of each field. You can use Text and all the digits will be kept.
 
Top