zero as first digit
 

how can i make zero appear and print as the value of the first digit in an
excel column?

If you want a fixed number of digits:

Format/Cells/Number/Custom 00000

will display 5 places, with the first digit 0 for numbers <=9999.

If you want to always display 0, regardless of the length of the number,
one way::


Format/Cells/Number/Custom \0General

or replace "General" with some other format.

In article ,
"oregonpapertrail" wrote:

how can i make zero appear and print as the value of the first digit in an
excel column?

A couple of ways, & the answer depends on what you need to do with it.

If you need it as a number, rather than as text, use a custom number format
such as:

000000

which will give you at least 6 digits no matter how many are entered.
You'll still be able to add, subtract, & otherwise use it in formulas

If you need it as text, say as a ZIP code so that if sorts correctly, then
format the cell as text and ENTER the value with the leading zeros

Formatting is changed with the FormatCells menu

"oregonpapertrail" wrote:

how can i make zero appear and print as the value of the first digit in an
excel column?