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 vote192 views1 answer
Vbide vbproject reference
VBA
1 vote190 views1 answer
How to open cmd with vbd
VBA
5 votes572 views1 answer
Vlookup vba
VBA
0 vote219 views1 answer
Vba code to select image in sheet
VBA
0 vote211 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote230 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote228 views1 answer
VB get external IP address
VBA
0 vote202 views1 answer
Excel autofilter vba
VBA
5 votes226 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote211 views1 answer
Vba get text file content
VBA