Show leading zeros (eg: 000123)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike C - 11 Mar 2008 05:25 GMT

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

Reply to this Message

Dale Levesque - 11 Mar 2008 09:11 GMT

http://support.microsoft.com/kb/81518
Have a look at this.

> 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

Reply to this Message

Dave Peterson - 11 Mar 2008 13:19 GMT

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.

> 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

Signature

Dave Peterson

Reply to this Message