Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers starting with 0
I have a group of 6 digit numbers starting with "0". When I enter this in
the cell, it shows up in the cell correctly. BUT up above the 0 gets dropped. I need the 0 to stay there. What can I do so the 0 does not drop off in the top box. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers starting with 0
1) type an apostrophe (single quote) before the number; it will not be
displayed or printed or 2) use a custom format of: 000000 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mccomb" wrote in message ... I have a group of 6 digit numbers starting with "0". When I enter this in the cell, it shows up in the cell correctly. BUT up above the 0 gets dropped. I need the 0 to stay there. What can I do so the 0 does not drop off in the top box. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers starting with 0
Precede the value with an apostrophe (single quote)
-- Gary''s Student - gsnu200808 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers starting with 0
use ( ' ) Apostrophe
On Oct 20, 7:27*pm, mccomb wrote: I have a group of 6 digit numbers starting with "0". *When I enter this in the cell, it shows up in the cell correctly. *BUT up above the 0 gets dropped. *I need the 0 to stay there. *What can I do so the 0 does not drop off in the top box. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers starting with 0
You can enter the numbers with an apostrophe in front of them, like:
'012345 The apostrophe will not show in the cell - this tells Excel to treat the cell as text. Or, you could pre-format the cells as text before entering your numbers. Or, you could apply a Custom format to the cells, set as "000000" - the numbers will be treated as numbers and can be used in calculations. Hope this helps. Pete On Oct 20, 3:27*pm, mccomb wrote: I have a group of 6 digit numbers starting with "0". *When I enter this in the cell, it shows up in the cell correctly. *BUT up above the 0 gets dropped. *I need the 0 to stay there. *What can I do so the 0 does not drop off in the top box. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
numbers starting with 0
One way is to preformat the col as TEXT
Or, enter a preceding apostrophe (both ways above will result in text numbers) Alternatively, if you need it to remain as real numbers but appear displayed with the preceding zeros, try preformatting the col as Custom, Type: 000000 Then just enter the nums as per normal. -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:62 xdemechanik --- "mccomb" wrote: I have a group of 6 digit numbers starting with "0". When I enter this in the cell, it shows up in the cell correctly. BUT up above the 0 gets dropped. I need the 0 to stay there. What can I do so the 0 does not drop off in the top box. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Store numbers starting with zero as 2 digit numbers | Excel Discussion (Misc queries) | |||
How do I quadruple numbers starting with 1, 2? | Excel Discussion (Misc queries) | |||
how can i move the starting point for the numbers numbers down. | Setting up and Configuration of Excel | |||
how do i enter numbers starting with zero in excel | Excel Discussion (Misc queries) | |||
how do I put in line numbers in the first colum starting in row A. | Excel Discussion (Misc queries) |