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

1 vote176 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote142 views1 answer
Excel vba arrondir
VBA
0 vote188 views1 answer
Make your computer talk vbscript
VBA
2 votes169 views2 answers
Constructor vb.net
VBA
0 vote183 views1 answer
Vba open report
VBA
0 vote176 views1 answer
Vbnet line graph smooth lines
VBA
0 vote195 views1 answer
Vba copy file
VBA
1 vote178 views1 answer
Vba reverse string
VBA
0 vote200 views2 answers
S yyyy-MM-dd em vb net
VBA
2 votes181 views1 answer
Excel vba date to string conversion
VBA