Excel formula with a number that contains a dash ex. 2030-0051

[KirkComeaux]

I am trying to create a formula to have consecutive number sequence by adding 1 to the cell, but since the number itself contains a dash (or in Excel's language minus) it is giving me an error. I used =A1(cell with number) +1. =A1+1. I am sure that I am not the first to have this issue but i could not find anything in help. 

[#2]

@KirkComeaux A "number" like 2030-0051 is in fact a text. Just drag it down and Excel should increment the text by 1 automatically. No formula needed.

[#3]

@KirkComeaux 

If build the series that's definitely as @Riny_van_Eekelen suggested. If for something else, variant could be

=LEFT( A1, 4 ) & "-" & TEXT( RIGHT( A1,4 )+1,"0000")