I would like to take the following number:

27800400158000011

and convert it to:

27 800 400 158000 011

There's one issue though... when I enter this:

27800400158000011

Excel will change the last two numbers to zero - it looks like this:

27800400158000000

I've tried to change the custom formats to 00000000000000000 but it still changes my data. I've also used this formula:

=LEFT(A1,2)&" "&MID(A1,3,3)&" "&MID(A1,6,3)&" "&MID(A1,9,6)&" "&RIGHT(A1,3)

but the formula will not work until I can fix the fact that it changed 011 to 000 at the end of the string.

Does anyone have any suggestions?

Thanks,

Pete