Displaying leading zeroes in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Jimtalbert

Thread Starter
Joined
Apr 6, 2001
Messages
214
How can I get EXCEL XP to display leading zeroes? For example, I want to enter a long number that begins with "0435" but can't get the cell to display anything other than "435". The number can be stored as text because I don't plan to use it in formulae, etc. However, when I format the cell as text I get a scientific notation display.
 
Joined
Aug 10, 2004
Messages
6,091
If you are using leading zeros, check your computer settings, under "my computer" / "control panel"/ "regional options": nubmers tab... select to display leading zero's.

I think there is another place to set this up also, I'll check and post back later.

You may be able to set EXCEL for leading zero's as well.

I had this problem between ACCESS and EXCEL, we did all this, and it fixed it.

the custome format also fixes it!

J
 
Joined
Aug 10, 2004
Messages
6,091
yeah, talked with the computer tech to refresh my memory, we changed the "date" format, for short date to mm/dd/yyyy, so that we would have leading zeros

geting:

01/01/2004

and not:

1/1/2004

you may need to do this as well if you are manipulating dates. otherwise I guess you're fine?

J
 

Jimtalbert

Thread Starter
Joined
Apr 6, 2001
Messages
214
Thanks for the additional suggestions. Couldn't find anything in the Control Panel setting other than leading zeros before a decimal point. I'm okay with the custom number format but it just seems there should be a simple generic option somewhere to permit leading zeros under all circumstances.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top