software

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

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.comquot;Diamonellequot;
gt; wrote
in message
news
gt;
gt; Hello,
gt;
gt; Can anyone tell me how to format numbers so they come out
gt; looking like
gt; this.
gt;
gt; Original number is :4601002122
gt; What I need the number to look like: 4601.00.21.22
gt;
gt; I have asked this question before, but the post is gone
gt; it's
gt; been over 2 years
gt;
gt; Thanks
gt;
gt; Diamonelle
gt;
gt;
gt; --
gt; Diamonelle
gt; ------------------------------------------------------------------------
gt; Diamonelle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=12756
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=522214
gt;
I also came up with this:

####quot;.quot;##quot;.quot;##quot;.quot;##quot;Chip Pearsonquot; wrote:

gt; Diamonelle,
gt;
gt; Use a custom number format of
gt;
gt; 0000\.00\.00\.00
gt;
gt; Note that there is a period following each \ character.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Diamonellequot;
gt; gt; wrote
gt; in message
gt; news
gt; gt;
gt; gt; Hello,
gt; gt;
gt; gt; Can anyone tell me how to format numbers so they come out
gt; gt; looking like
gt; gt; this.
gt; gt;
gt; gt; Original number is :4601002122
gt; gt; What I need the number to look like: 4601.00.21.22
gt; gt;
gt; gt; I have asked this question before, but the post is gone
gt; gt; it's
gt; gt; been over 2 years
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Diamonelle
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Diamonelle
gt; gt; ------------------------------------------------------------------------
gt; gt; Diamonelle's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=12756
gt; gt; View this thread:
gt; gt; www.excelforum.com/showthread...hreadid=522214
gt; gt;
gt;
gt;
gt;


Thank you , both workperfectly...! --
Diamonelle
------------------------------------------------------------------------
Diamonelle's Profile: www.excelforum.com/member.php...oamp;userid=12756
View this thread: www.excelforum.com/showthread...hreadid=522214