dashed numbers

[macfarlane]

I need to make a field of this number 0-375-001 ascending by one's. The dash
is giving me trouble. When I pull the cells, & reach 999 times the number
becomes 0-375-1000 but I need it to click to 0-376-000. I would have to make
about 185 of these fields because the number won't click higher next to the
immediate dash to the left of the zero. Is there any way to make a continuous
field when you have dashes in the number? Thank you in advance with any help.

 

[Paul Lautman]

I need to make a field of this number 0-375-001 ascending by one's.
The dash is giving me trouble. When I pull the cells, & reach 999
times the number becomes 0-375-1000 but I need it to click to
0-376-000. I would have to make about 185 of these fields because the
number won't click higher next to the immediate dash to the left of
the zero. Is there any way to make a continuous field when you have
dashes in the number? Thank you in advance with any help.

Enter the first number as 375001 then do Ctrl-1 and on the Number tab select
Category Custom

Then in the Type field enter 0-###-###

Then do your drag

 

[Don Guillett]

In cell a1, format>custom>0-000-000
in cell a2 =a1+1

 

[macfarlane]

Thank You all so much. Will try.
--
vince nemi

A Format/Cells/Numbers/Custom set to 0-###-### will limit the last 3 nos to
a max of 999

Leon