H
help
how could i add zeros as the first number in a cell without a decimal
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kassie
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
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
C
CLR
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
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
F
Fred Holmes
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