View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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.