Excel Formula Help

[Fuisdale2]

Thank you for taking the time to read my post.

I have the below formula which works out if there changes between 2 worksheets which has the same data in the corresponding columns/cells.

For reference "MHL_Data" is from the Client and "SDB_Data" is the data export from our system.

The issue I have is that our "SDB_DATA" in one of the columns has the Data Stored as text and the corresponding column Data from the client has this in Number format.

Is there a way of amending the formula to read the data in our "SDB_Data" tab column as Number instead of the stored text without having to manually format the data in that column from Stored Text to Number?




=IF(MHL_Data!B2<>SDB_Data!C6, "MHL TAB:"&MHL_Data!B2&" vs SDB TAB:"&SDB_Data!C6, "")

 

[Joe4]

If you have numbers entered as Text, one way to coerce them to numeric value is to perform a simple mathematical computation on them, like adding zero or multiplying by one, i.e.

[COLOR=#333333]=IF(MHL_Data!B2<>[/COLOR][COLOR=#ff0000](SDB_Data!C6 + 0)[/COLOR][COLOR=#333333],...[/COLOR]

 

[Fuisdale2]

Thank you for helping me out, your formula worked.


Thank you.

 

[Joe4]

You are welcome.