Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In excel how do i put zero as the first Number in a cell
how could i add zeros as the first number in a cell without a decimal
|
#2
|
|||
|
|||
Hi
Two ways: Start your entry with an ', to read '083, or Format the cells where you want to insert this as text, and then enter the number "help" wrote: how could i add zeros as the first number in a cell without a decimal |
#3
|
|||
|
|||
Either format the cell for TEXT (Right-click FormatCells NumberTab
Text ok), or if you only have a few, just type a leading apostrophe before the leading zero.........it won't show up and will change that cell to TEXT format.......... Vaya con Dios, Chuck, CABGx3 "help" wrote in message ... how could i add zeros as the first number in a cell without a decimal |
#4
|
|||
|
|||
On Sun, 1 May 2005 12:31:02 -0700, "help"
wrote: how could i add zeros as the first number in a cell without a decimal Not sure really what you are asking for, but if you Format, Cells, Custom and enter, for example "00000" as the custom format, then when you enter the number "123" into the cell, it will display as "00123". This keeps the data in the cell numeric and you can process it in formulae as a number. Fred Holmes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
How do I start an Excel entry with then number 0? | Excel Discussion (Misc queries) | |||
VARYING number of sheets in EXCEL | New Users to Excel | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
how to get week number in month in excel ? | Charts and Charting in Excel |