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
|