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

1 vote121 views1 answer
Excel vba last row of range
VBA
0 vote116 views1 answer
Vb check if row has column
VBA
0 vote112 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote131 views1 answer
Vbscript check if string contains
VBA
0 vote115 views1 answer
Hello world vb.net
VBA
0 vote116 views1 answer
Vba change named range address
VBA
0 vote116 views1 answer
Excel vba cell on change
VBA
0 vote115 views1 answer
Excel vba formatconditions range
VBA
4 votes107 views1 answer
Excel vba check cell not empty
VBA
1 vote134 views1 answer
Excel vba convert text YYYYMMDD to date
VBA