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 vote133 views1 answer
Vba sendkeys
VBA
0 vote136 views1 answer
Excel vba join variant array
VBA
0 vote143 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote150 views1 answer
Vba array dimensions
VBA
2 votes141 views1 answer
Excel vba check if key is in collection
VBA
0 vote97 views1 answer
Vbide vbproject reference
VBA
3 votes149 views1 answer
Vba make long from two words
VBA
0 vote127 views1 answer
Docker vboxmanage not found
VBA
0 vote147 views1 answer
Filesystemobject vba reference
VBA
0 vote131 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA