I have a column of numbers that I'm trying to do the "Mid" function on, and return the last digit but it' keeps returning the #VALUE! error

It just happens in this this worksheet. When I create a new worksheet in the same workbook and create these numbers again, the formula works fine. I can even do a mid function, calling on the column of numbers from the original worksheet and it gives me a good answer. But using the mid function on this worksheet alone gives me the error.

I have...

-Made sure everything is in the number is in "Number" format

-I've changed the number to letters and the mid function works fine on the original worksheet

Any Ideas why this happens? Thanks for any input.