Home

working on a series

MBARRY95
Occasional Visitor

I have tank numbers that go up starting at 19-140-001 then 19-140-002, 19-140-003, etc How fo I set up the series to fill the column down with that order?

2 Replies
Select the first 2 numbers and drag down the rows to fill the series. Thereafter, format the cells with this custom number format:
00-000-000

@MBARRY95 , I guess actually these are texts. Simple drag down of first one shall work.