Converting a list of numbers...

[Gordon MacDonald]

I have a list of 6 digit numbers that I need to change the format.
They are currently 123456 and I need them to be 12.34.56. Is there
any easy way to do this? Please replay by email to
(e-mail address removed)...

Many thanks.

 

[Electra]

if the numbers are always 6 digits then adding the following custom
format will work:

1. hilight the range
2. select format
3. select cells
4. select number
5. select custom (at bottom of list)
6. type the following in the type field:
00"."00"."00".";General;General;General
7. select ok