Irregular Number Formating
 

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
------------------------------------------------------------------------
Diamonelle's Profile: http://www.excelforum.com/member.php...o&userid=12756
View this thread: http://www.excelforum.com/showthread...hreadid=522214

Irregular Number Formating
 

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"
wrote
in message
...

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
------------------------------------------------------------------------
Diamonelle's Profile:
http://www.excelforum.com/member.php...o&userid=12756
View this thread:
http://www.excelforum.com/showthread...hreadid=522214

Irregular Number Formating
 

I also came up with this:

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


"Chip Pearson" wrote:

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"
wrote
in message
...

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
------------------------------------------------------------------------
Diamonelle's Profile:
http://www.excelforum.com/member.php...o&userid=12756
View this thread:
http://www.excelforum.com/showthread...hreadid=522214

Irregular Number Formating
 

Thank you , both workperfectly...! :)


--
Diamonelle
------------------------------------------------------------------------
Diamonelle's Profile: http://www.excelforum.com/member.php...o&userid=12756
View this thread: http://www.excelforum.com/showthread...hreadid=522214