Number format

  • Thread starter Thread starter carg1
  • Start date Start date
C

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
 
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?
 
Back
Top