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 vote365 views2 answers
VB
VBA
0 vote243 views1 answer
Ribbon show/hide
VBA
0 vote228 views1 answer
Hello world vb.net
VBA
1 vote240 views1 answer
Add a index column power bi
VBA
0 vote263 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote232 views1 answer
Vbscript abs
VBA
0 vote301 views1 answer
Visual basic run command
VBA
0 vote236 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote219 views1 answer
Vba file size
VBA
0 vote260 views1 answer
Iterate all file in a folder vba
VBA