Vba format currency

' 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

Similar codes

0 vote157 views1 answer
Make your computer talk vbscript
VBA
0 vote151 views3 answers
Write to text file vb.net
VBA
0 vote150 views2 answers
Get excel file from email attachment in vba
VBA
0 vote234 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote170 views1 answer
Vba table header name
VBA
1 vote147 views1 answer
Excel vba saveas force overwrite
VBA
2 votes151 views1 answer
Excel vba extract file name
VBA
0 vote156 views1 answer
Internet explorer reference vba
VBA
0 vote157 views1 answer
Excel vba cell on change
VBA
0 vote163 views1 answer
Check if program is running vbnet
VBA