Custom Format on 16 Digit Number
Yes, something like
000-000-000
will do it, but as has been noted previously, Excel number precision is to
15 digits
HTH
Bob
"Neil" wrote in message
...
Niek:
I don't know of a way to format a text field to insert dashes
automatically
does one exist?
--
Neil
"Neil" wrote:
When I try to format a 16 digit number into 1111-2222-3333-4444 the last
number is displayed as a "0". How do I get the last number to display
correctly?
--
Neil
|