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
|