Vba Format Currency

[Solved] Vba Format Currency | Vb - Code Explorer | yomemimo.com
Question : vba format currency

Answered by : vastemonde

' If A1 value is 2021,543
With Range("A1") .NumberFormat = "€#,##0.00" ' -> €2021,54 .NumberFormat = "$ #,##0.00" ' -> $ 2021,54 .NumberFormat = "#,##0.00 €" ' -> 2021,54 € .NumberFormat = "#,##0€" ' -> 2022€ Debug.Print .NumberFormat	' -> #,##0€
End With

Source : | Last Update : Sat, 13 Feb 21

Answers related to vba format currency

Code Explorer Popular Question For Vb