In excel how do i put zero as the first Number in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
how could i add zeros as the first number in a cell without a decimal
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Excel 2007 adding a column of negative and positive number 2
end a number in ZERO 3
Red cell for negative numbers in Excel 1
Question about conditional formatting of zeros in Excel 0
Formatting zeros as dashes 4
How to retain decimal zeroes? 5
How do I begin value with the number zero? 2

Back
Top