View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Custom Number Format

Rather than Cusstom Format, format the cell as tet and enter the - manually:

1-2-3-4-5-6-7-8-9-0-1-2-3-4-5-6
--
Gary''s Student - gsnu200750


"CNB Cheryl" wrote:

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