Converting a list of numbers...

G

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
[email protected]...

Many thanks.
 
E

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
 
Top