Thread: CELL FORMAT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
William William is offline
external usenet poster
 
Posts: 119
Default CELL FORMAT

In a worksheet cell A1 is in General format, and has the entry 0607. Cell A2
(same column) is also in General format, but has 607. When I add the 0 at
the front 607, Excel deletes the zero as soon as I click outside the cell. I
don't understand how that can happen since both cells are in General format.
What is causing one cell to accept the 0 at the front but not the other?
--
William