Hi
no there isn't. as Excel allows only 15 significant digits for a
numeric value you can't have a custom number format with 16 digits. So
this would require VBA (using an event procedure)

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve Jones" schrieb im Newsbeitrag
...
Hi Frank

I was looking at the same thing yesterday by coincidence and came up
with
same answer as you have given.

Is there anyway in Custom format you can Enter the sixteen numbers
with a
space/hyphen between each set of four?

I've tried various options with no success.

Thanks

Steve
"Frank Kabel" wrote in message
...
Hi
either preformat the cell as 'Text' or precede the entry with an
apostrophe. e.g.
'1234567890123456

--
Regards
Frank Kabel
Frankfurt, Germany

"ceking" schrieb im Newsbeitrag
...
How do we get the last digit to hold