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

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

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

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