specify number format

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- wrote:
> 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.

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

-D- wrote:
>
> 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

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

this will give you what you want.

Regards,
Dodong