Hi Michael,

Am Fri, 17 May 2013 04:25:06 -0700 (PDT) schrieb :

I have tried that already, doesn't seem to do anything.

click in column header = Format "General" = TextToColumns = Fixed
Width = Finish = Custom numberformat 0000 000 0000

If that not works try:
=LEFT(A1,4)&" "&MID(A1,5,3)&" "&RIGHT(A1,4)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2