specify number format

[-D-]

I have a column that requires 5 numbers:

I want to prefix with zeros any number that doesn't meet the required 5
digits.


Is there a way to format the column with this structure and in the future if
the file is modifed that it will automatically adjust the column, so that if
someone types in:

123 that the result would be 00123
or
1234 then the result would be 01234

How can I accomplish this?

Thank you.

 

[dodong]

I have a column that requires 5 numbers:

I want to prefix with zeros any number that doesn't meet the required 5
digits.


Is there a way to format the column with this structure and in the future if
the file is modifed that it will automatically adjust the column, so that if
someone types in:

123 that the result would be 00123
or
1234 then the result would be 01234

How can I accomplish this?

Thank you.

 

[Dave Peterson]

Select that column
Format|cells|Number tab|Custom category
type in: 00000
in the "Type:" box

 

[dodong]

Under format menu go to custom then under Type put 00000 then ok

this will give you what you want.

Regards,
Dodong