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 vote286 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote268 views1 answer
Show unix time in vba
VBA
1 vote255 views1 answer
Vba delete array element
VBA
0 vote270 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote267 views1 answer
Vba verticalalignment
VBA
22 votes384 views1 answer
Excelvba check for directory
VBA
0 vote196 views10 answers
Vba excel create event log
VBA
0 vote293 views1 answer
Excel vba set cell value to empty
VBA
0 vote274 views1 answer
Vba copy file
VBA
1 vote266 views1 answer
Excel vba autofit
VBA