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 vote233 views1 answer
Vba check if class implements interface
VBA
0 vote244 views1 answer
Vba code to select image in sheet
VBA
5 votes248 views1 answer
Excel vba left word from Long Integer
VBA
0 vote250 views1 answer
VBA is form loaded
VBA
0 vote211 views1 answer
Vbnet line graph smooth lines
VBA
1 vote237 views1 answer
Set font for ms chart vb.net
VBA
0 vote223 views1 answer
Vbscript remove spaces from string
VBA
31 votes480 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote229 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote235 views1 answer
Excel vba prevent saving workbook
VBA