Hello all,
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
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