hoanganhdl
New Member
- Joined
- Dec 9, 2016
- Messages
- 2
Code:
Sub test()
Application.DecimalSeparator = ","
Application.ThousandsSeparator = "."
Application.UseSystemSeparators = False
MsgBox Format("123456", "#,##0")
Exit Sub
I want result is 123.456 but it is 123,456.