View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CNB Cheryl CNB Cheryl is offline
external usenet poster
 
Posts: 1
Default Custom Number Format

I need to have a 16 digit number with - between each number. I created a
custom format, however the 16th digit always reverts to 0 (zero). I need
this to accept all the numbers that are entered into the field. We are on a
deadline so any help is appreciated. I have tried comma's and other items,
but no go...

Thanks
CNBCheryl