Number format

[carg1]

I'm trying to mess around with the number formats to make it displa
numbers with multiple periods as a seperator. More precisely, I wan
to create a number format that would make a number like this one:

5489782536

Look like this:

5489.78.25.36

I've only tried it with a custom number format so far, and all m
efforts throw in a ton of trailing zeroes or places the periods afte
the number. Is there a way to do it

 

[RagDyer]

Try this custom format:

####\.##\.##\.##

Spaces added for clarity:
#### \ . ## \ . ## \ . ##
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I'm trying to mess around with the number formats to make it display
numbers with multiple periods as a seperator. More precisely, I want
to create a number format that would make a number like this one:

5489782536

Look like this:

5489.78.25.36

I've only tried it with a custom number format so far, and all my
efforts throw in a ton of trailing zeroes or places the periods after
the number. Is there a way to do it?

 

[Dave Peterson]

and another one based on RagDyer's:

0000\.00\.00\.00