Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
Hi,
check cell A1 it should have ' at the beginning, you can custom format the cell to reflect the 0 as 0000 "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
Just format the cell as Text and enter try to enter the value
Select the range and do Right Click and select Format CellsNumberCategoryText and give ok. Otherwise before entering the value in a cell type ' and enter your Zero value numbers. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
Thanks to all!
-- William "Ms-Exl-Learner" wrote: Just format the cell as Text and enter try to enter the value Select the range and do Right Click and select Format CellsNumberCategoryText and give ok. Otherwise before entering the value in a cell type ' and enter your Zero value numbers. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
CELL FORMAT
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 -- David Biddulph "William" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |