Dim A,B, C As Double
A= 4100.00 :B= 212.4000000656
C=A+B
Msgbox(MyCurrencyFormat(C),"") 'returns: $4,312.40
Sub MyCurrencyFormat(MyNumber As Double) As String
Dim AHL As AHLocale 'need the AHlocale library
AHL.InitializeUS
Dim MyCur As String =AHL.CurrencySymbol
Dim MyFrac As Int =AHL.CurrencyFractionDigits
Return MyCur & NumberFormat2(MyNumber,1,MyFrac,MyFrac,True)
End Sub