Irregular Number Formating

[Diamonelle]

Hello,

Can anyone tell me how to format numbers so they come out looking like
this.

Original number is :4601002122
What I need the number to look like: 4601.00.21.22

I have asked this question before, but the post is gone it's
been over 2 years

Thanks

Diamonelle

 

[Chip Pearson]

Diamonelle,

Use a custom number format of

0000\.00\.00\.00

Note that there is a period following each \ character.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Diamonelle"
in message
news[email protected]...

 

[Guest]

I also came up with this:

####"."##"."##"."##

Diamonelle,

Use a custom number format of

0000\.00\.00\.00

Note that there is a period following each \ character.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Diamonelle"
in message

 

[Diamonelle]

Thank you , both workperfectly...!