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 remove numbers from string
VBA
0 vote216 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
1 vote230 views1 answer
Excel vba array remove first
VBA
0 vote212 views1 answer
Excel vba remove formatting from cell
VBA
0 vote278 views1 answer
Visual basic run command
VBA
2 votes206 views1 answer
Vba uppercase first letter of each word
VBA
0 vote251 views1 answer
Excel vba unlock sheet without password
VBA
0 vote222 views1 answer
Excel named range sum
VBA
1 vote229 views1 answer
Export datagridview to excel vb.net
VBA
0 vote167 views1 answer
How to sort datagridview in vb.net
VBA