specify number format

  • Thread starter Thread starter -D-
  • Start date Start date
D

-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.
 
-D- said:
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.
Click to expand...
 
Select that column
Format|cells|Number tab|Custom category
type in: 00000
in the "Type:" box
 
Under format menu go to custom then under Type put 00000 then ok

this will give you what you want.

Regards,
Dodong
 
Back
Top