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 vote141 views1 answer
Excel vba disable screen update
VBA
1 vote148 views2 answers
Vba string to date
VBA
0 vote154 views1 answer
Vba type
VBA
0 vote153 views1 answer
Vba full date format
VBA
0 vote148 views1 answer
Vbnet hex to binary
VBA
0 vote154 views1 answer
Excel R1C1 mode
VBA
1 vote163 views1 answer
Add rows to datagridview vb.net
VBA
0 vote170 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote153 views1 answer
Vba parameter adodb null value
VBA
0 vote196 views1 answer
Vba ternary
VBA