Type Conversion Errors In VBA Code

I have an existing code that runs almost flawlessly but I am running in to formatting cells error (or at least I think that is the problem).

For example, here is a line of code where my error lies:

If Worksheets(FirstSheet).Cells(Counter, ColtoMove) = MoveIf Then
'DO SOME ACTION

If I put my cursor on MoveIf it shows the expect number of 4500016239…….BUT it errors!

When I step through the code and go to the worksheet (or go to the left side of the = in the above code the data in the cell is “4.5E+09“.

I’ve attempted to change the formatting of this cell range to “Text” by the following With statement:

With Worksheets("CreateOrderFormsData")
.Range("AC:AC").NumberFormat = "Text"
End With

Note: if I verify the cells formatting after the above code is ran by rt click on the cell, format cells the Number field is set to “CUSTOM” and the Type: field is set to “TEXT”. Is this the problem? Please read on.

But that did not seem to do the trick…..actually if I now go to the left of the = again (which is now set to text) the data is “###########” in the cell, in the formula bar the number is the expected 4500016239 though but the CODE STILL FAILS!

Am I on the right track…..can anyone assist with this error please?