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 vote210 views1 answer
Vba min
VBA
0 vote198 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote228 views1 answer
Vba code for cutoff time
VBA
0 vote204 views1 answer
Find days in month vba
VBA
0 vote201 views1 answer
Vba get relative cell address
VBA
0 vote206 views1 answer
Rotate image by any angle vb.net
VBA
5 votes221 views1 answer
Excel vba left word from Long Integer
VBA
1 vote230 views1 answer
Excel vba first row in range
VBA
5 votes183 views1 answer
Vba array worksheet.index
VBA
1 vote203 views1 answer
Add control vb
VBA