Text entries behaving like numbers
I've got some text entries in Column A1 through A6 as follows:
11-1021
11-3021
11-3051
11-9021
11-9041
13-1073
I've written a short test formula in cells B1 through B6 as follows:
=A1*1
=A2*1
=A3*1
=A4*1
=A5*1
=A6*1
The formula results in cells B1 through B6 as follows:
#VALUE! (as expected)
409743
420700
2601198
2608503
#VALUE! (as expected)
The results in cells B1 and B6 are as I expect, but I can't get rid of the
numbers in cells B2 through B5.
It appears the entries in cells A2 though A5 are behaving like numbers. For
instance, if I change the entry in A3 to 11-3021 the formula result changes
to 409743. I've checked and double-checked the formatting.
Any idea what's going on?
Thanks
|