Mid function returning #value error

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.

Tried

=MID(A1,1,1)+0

and

=MID((A1+0),1,1)

Still returns "#Value!" error.


FYI

Cell A1 is equal to 10
and
cell A2 is equal to 15

so when I enter "=A1+A2" it gives me 25

(Just showing that these are actual numbers)

Hi

If all you want is the last digit perhaps using the RIGHT function would work better, e.g.

Please Login or Register  to view this content.

regards


Jeff

Since you say the problem is isolated to a single sheet and works fine if recreated, I'd just recreate the whole sheet and move on.

solnajeff is right about using RIGHT to get the last digit, whatever you decide.