I think that Excel only allows 15 digits, so the 16th you are entering will
be always 0, if you are using a number format.
One solution is format the cell as text, and then use a formula to add the
spaces, something like:
=LEFT(A1,4) & " " & MID(A1,5,4) & " " & MID(A1,9,4) & " " & RIGHT(A1,4)
It is not as neat as a custom format, but it may do the trick.
Enter the number into cell A1 with a leading single quote mark, to make it a string.
HTH,
Bernie
MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.