Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel ignore a 0 if it starts out that way
I am trying to create a spread sheet and need to enter 0023408 and it wants
to put 23408. I need the 00 to be there. How can I turn this feature on or off. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel ignore a 0 if it starts out that way
Right-click on the cell, go to "format cell";
Under the "number" tab, choose "Custom" in the category mini-window; In the white space underneath "Type:", replace whatever you have in there (possibly "General") by "0000000"; Click "OK"; Done! "Cali Tech" wrote: I am trying to create a spread sheet and need to enter 0023408 and it wants to put 23408. I need the 00 to be there. How can I turn this feature on or off. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel ignore a 0 if it starts out that way
format the cell with a custom format of
0000000 Note however that the cell hold the value 23408 and that only the format of the cell has changed. -- HTH... Jim Thomlinson "Cali Tech" wrote: I am trying to create a spread sheet and need to enter 0023408 and it wants to put 23408. I need the 00 to be there. How can I turn this feature on or off. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel ignore a 0 if it starts out that way
Another option, but it'll be text numbers
Either precede the input with an apostrophe (') or, pre-format the col as text. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Cali Tech" wrote: I am trying to create a spread sheet and need to enter 0023408 and it wants to put 23408. I need the 00 to be there. How can I turn this feature on or off. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel ignore a 0 if it starts out that way
If you have a "bunch" of numbers like that and all of them need to be the
same number of digits you can use a custon number format: FormatCellsNumber tabCustom 0000000 If you enter 10 it will *appear* as 0000010. If you enter 23408 it will *appear* as 0023408. These entries will still be *numbers*. Or, you can enter them as *TEXT*. You can either preformat the cells as TEXT or you can precede them with an apostrope as you enter them: '0023408 -- Biff Microsoft Excel MVP "Cali Tech" wrote in message ... I am trying to create a spread sheet and need to enter 0023408 and it wants to put 23408. I need the 00 to be there. How can I turn this feature on or off. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sometimes Excel starts but its screen is blank? | Setting up and Configuration of Excel | |||
excel starts incorrectly | Excel Discussion (Misc queries) | |||
Strange message when Excel starts. | Excel Discussion (Misc queries) | |||
Excel starts sorting from row 210 Why? | Excel Discussion (Misc queries) | |||
Excel starts and shuts down | Excel Discussion (Misc queries) |