Irregular Number Formating

  • Thread starter Thread starter Diamonelle
  • Start date Start date
D

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, :eek: but the post is gone it's
been over 2 years

Thanks :cool:

Diamonelle
 
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:D[email protected]...
 
I also came up with this:

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


Chip Pearson said:
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
Click to expand...
 
Back
Top