How do I begin value with the number zero?

S

sportsandspeed

Dumb question, but how do I begin a cell value with the number zero? I've
tried changing the cell format to text and that didn't work. I also tried
putting a ' in fornt and that worked until I closed the file and reopened it.
After reopening, the zero was missing again. By the way, I'm using Excell
2003.
 
J

Joerg Mochikun

Maybe Format|Cells|Custom, then try '000' (without quotes) for 3 digit
numbers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to show numbers that begin with 0 in excel 2
Leading Zero 11
Custom Number Format for text 8
The number zero 1
conditional format change 3
Addiing a Zero to a number which is already there 1
ZERO VALUE NOT WORKING 2
How do I type number that begins with a zero to keep zero? 4

Top