Text and Numeric Cells

[HeavyMusic]

Hi,

I have two columns in my worksheet. In the cells, it has a text of "6-62" and converted into number is 22798. Other text cells are 12345 and converted to numbers are 12345. I am trying to do a if statement or text function to isolate the "6-62". If I do the if statement to say if 6-62 = 22798, say YES otherwise NO. It always says Yes. Using the text function, It shows that "6-62 and 22798 are not equal. But it also gives me the same for the text 12345 that in number format 12345 are not equal. Again , just trying to isolate where the text 6-62 is different that the converted text to number result of 22798. Thanks

 

[Micron]

If you're asking how 6-62 becomes 22798 then it's being interpreted as a date - June 01 1962 whereas 12345 is interpreted as either a string or a number.
AFAIK, if you change a cell format from say, text to number, you usually have to re-enter the value, else it has no effect on the cell contents. That's what I had to do to replicate your experience. Then again, by "converted into number is 22798" you might not have been referring to cell formatting, but fairly certain I can say that formatting has no effect on the data type.
I get an error flag if I enter 6-62 or '6-62

 

[Snakehips]

@HeavyMusic Welcome
Not sure that I fully understand your data setup but maybe this helps?

Book2
	A	B	C	D	E	F
1	Data A	Data B			ISNUMBER	ISNUMBER
2	6-62	22798			FALSE	TRUE
3	12345	12345			FALSE	TRUE
4	6-62	22798			FALSE	FALSE
5	12345	12345			TRUE	TRUE
Sheet3

Cell Formulas
Range	Formula
E2:F5	E2	=ISNUMBER(A2)
B2:B3	B2	=--(A2)