Thread: CELL FORMAT
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CM CM is offline
external usenet poster
 
Posts: 136
Default CELL FORMAT

William,

You will need to format cells as 'Text' in order to get the applicaiton to
accept a leading zero -- otherwise it will recognize it as a number.

"William" wrote:

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