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.