View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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