Calculation/Number Bug in .xls? Any ideas?
Just another option is the Currency symbol @:
Sub Demo()
If (329970.14@ + 1012000) = 1341970.14 Then
MsgBox "Match"
Else
MsgBox "Not match"
End If
End Sub
--
Dana DeLouis
"AB" wrote in message
...
it just proves what a newbie I am...
It's very good to know - thanks a lot Nigel/Charles!!
|