how can a two digit # be set up with 2 0's at the beginning 0025

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Linda - 23 Aug 2006 20:32 GMT

How can I set up my spreadsheet with one column that will have a four place
number (0000) or if a number is 25 will put two zeros in front of that
number.

Example: 0025
or 0000
or 0045
The column would change the numbers to 0000 if a number is not there or if a
two digit number is there it would change the cell to two zeros in front of
the two digit number 0045.

Reply to this Message

tim m - 23 Aug 2006 20:59 GMT

Format....cells....custom, choose any type and in the box just below type:
enter 0000

> How can I set up my spreadsheet with one column that will have a four place
> number (0000) or if a number is 25 will put two zeros in front of that
[quoted text clipped - 6 lines]
> two digit number is there it would change the cell to two zeros in front of
> the two digit number 0045.

Reply to this Message

Gord Dibben - 23 Aug 2006 22:38 GMT

Linda/tim

I'm still trying to figure out how to format to get 0000 if no number in the
cell.

Gord Dibben MS Excel MVP

>Format....cells....custom, choose any type and in the box just below type:
>enter 0000
[quoted text clipped - 9 lines]
>> two digit number is there it would change the cell to two zeros in front of
>> the two digit number 0045.

Reply to this Message