alex009988
07-25-2019, 12:11 PM
Sub test()
Dim a As Double
a = 10000000.56
'Selection.Style = "Comma"
MsgBox "Output: " & a
End Sub
So I want to get 10000000.56 as 10 000 000.56 kinda AccountingForm.
Is there some inbuild function for msgbox to do that?
Or I should convert double to the string and use...?
Thanks in advance!
Alex
Dim a As Double
a = 10000000.56
'Selection.Style = "Comma"
MsgBox "Output: " & a
End Sub
So I want to get 10000000.56 as 10 000 000.56 kinda AccountingForm.
Is there some inbuild function for msgbox to do that?
Or I should convert double to the string and use...?
Thanks in advance!
Alex