In cell B7, I have the number 32-338, but because of the "-" , excel thinks it's text. Is there a way to get 32-338 as a number?
The end point is that I need it to look at cell B7, get the number (in this case 32-338) and then also give me the previous and next numbers (32-337 and 32-339)
I tried
, but that turns it into 32.
I also can't assume that the numbers on the right will always be two digits, or that the numbers on the left will be three.