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 vote240 views2 answers
Excel vba number format file size
VBA
3 votes198 views1 answer
Excel vba read registry key value
VBA
2 votes202 views2 answers
Constructor vb.net
VBA
0 vote213 views1 answer
Excel run macro every 5 minutes
VBA
0 vote194 views1 answer
Add items to combobox vb.net
VBA
0 vote216 views1 answer
Vba remove the first character of string
VBA
0 vote225 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote216 views1 answer
Vba compare strings
VBA
0 vote213 views1 answer
Set column width of datagridview vb.net
VBA
4 votes251 views1 answer
VBA Deep Clone Dictionary
VBA