Formatting to show 0 as first number in a cell when input

T

triffidbook

How do I format a cell so it automatically shows a 0 as the first digit when
I input a numeric value insted of using the ' prefix? The cell is used for
order numbers which can begin with a 0
 
M

Max

One way ..
Assuming its a 5 digit series (00000)
Select the col,
Click Format > Cells > Number tab
Choose Custom, type: 00000
Click OK
 
D

David Biddulph

triffidbook said:
How do I format a cell so it automatically shows a 0 as the first digit
when
I input a numeric value insted of using the ' prefix? The cell is used
for
order numbers which can begin with a 0
Click to expand...

Format the cell as text prior to entering the data.
 
M

Max

You're welcome. Do note the subtle difference: David's method changes the
source numbers to text while my suggestion preserves it as numbers.
 
Top