Cell A = Cell B but Excell thinks it doesn't

[oswalda]

I have values in column A and values in column B. Both columns are formatted as General. A is a number and B is also a number generated from a formula
Both lines below have the same numbers in rows 1 and 2. Excell thinks row 1 numbers are equal and row 2 numbers are not equal

Why does Excell see the number in B2 as different than the number in A2?
thanks

 

[MARK858]

A is not a number, as you state in the image it is text (which is what it is in column A below).

Try the formulas in C3 or C4, where you replace the b cell reference with your formula that you haven't posted.

Book1
	A	B	C
2	123456	123456	FALSE
3	123457	123457	TRUE
4	123458	123458	TRUE
Sheet3

Cell Formulas
Range	Formula
C2	C2	=A2=B2
C3	C3	=A3+0=B3
C4	C4	=A4+0=ROUND(B4,0)

 

[oswalda]

=A3+0=B3 turned C3 to False so that isn't right

values in Col A should equal values in Col B
Cell B2 has =A2=B2 and returns TRUE, which is correct
Cell B3 has the same formula but returns False.

I tried theother formulas you suggested they both return FALSE

 

[MARK858]

I tried theother formulas you suggested they both return FALSE

Then try posting the formula in column B that you are using so we have a clue what we are dealing with

I take it you meant
Cell C2 has =A2=B2 and returns TRUE, which is correct
Cell C3 has the same formula but returns False.

 

[oswalda]

Here is the formula
=VALUETOTEXT(VLOOKUP($E2,'E:\NYCHHC\CSOD\Reports\Historical Data\[UsersforFeedComparison 5-29-2024.xlsx]Users for Feed Comparison'!$B$13:$L$25741,6,FALSE))

 

[MARK858]

What result do you get in column B if you remove the Valuetotext function and format the cell to 15 decimal places?

Also try

=TRIM(A2)=TRIM(B2)

 

[oswalda]

Adding Trim makes it work
thanks so much for your help

 

[MARK858]

You're welcome, it probably means you have an extra space in the cells somewhere