Show leading zeros (eg: 000123)

  • Thread starter Thread starter Mike C
  • Start date Start date
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
 
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.
 
Back
Top