CELL FORMAT

  • Thread starter Thread starter William
  • Start date Start date
W

William

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?
 
Hi,
check cell A1 it should have ' at the beginning, you can custom format the
cell to reflect the 0 as 0000
 
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.
 
Just format the cell as Text and enter try to enter the value

Select the range and do Right Click and select Format
Cells>>Number>>Category>>Text and give ok.

Otherwise before entering the value in a cell type ' and enter your Zero
value numbers.

If this post helps, Click Yes!
 
Thanks to all!
--
William


Ms-Exl-Learner said:
Just format the cell as Text and enter try to enter the value

Select the range and do Right Click and select Format
Cells>>Number>>Category>>Text and give ok.

Otherwise before entering the value in a cell type ' and enter your Zero
value numbers.

If this post helps, Click Yes!
Click to expand...
 
The difference is that the content of A1 is the text string 0607, whereas
the content of A2 is the number 607.
You can confirm this by seeing that =ISTEXT(A1) and =ISNUMBER(A2) will show
TRUE, whereas =ISTEXT(A2) and =ISNUMBER(A1) will show FALSE.

Formatting the cell will affect only cells containing a number, & will not
affect text. If you want to display the leading zero for the number 607,
custom format as 0000
 
Back
Top