| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I begin value with the number zero?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I begin value with the number zero?
Ensure Zero values is checked. Go to Tools|Options, View tab.
-- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "sportsandspeed" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I begin value with the number zero?
Maybe Format|Cells|Custom, then try '000' (without quotes) for 3 digit
numbers "sportsandspeed" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering numbers that begin with zero | New Users to Excel | |||
| I dont know where to begin :( | Excel Discussion (Misc queries) | |||
| Hmmm, where do I begin? | Excel Discussion (Misc queries) | |||
| Zip codes that begin with a zero... | Excel Worksheet Functions | |||
| how do i begin to use excel? | New Users to Excel | |||
Linear Mode
