View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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!!