[RESOLVED] Currency Format..

[zaza]

Hi,

Is this actually in a VBA Userform or in an Excel cell?

If in a userform:

Label1.Caption = Format(Label1.Caption, "€ #,##0.00")

If in a cell:

Selection.NumberFormat = "[$€] #,##0.00"

or replace Selection with the cell or range reference.


The Currency format works from your Windows locale settings and can't be directly changed.


zaza