[RESOLVED] Currency Format..

Hi I want to show some data in currenct format in my form..Iam doing this by using

VB Code:

format(1000,"Currency")

with this im gettig $1000 ..but according to the requirement it should not be "Dollor" it should be "EURO (€)"

So what i have to do for this???Please help me..

thanx & regards
Srikanth

Hi,

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

If in a userform:

VB Code:

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

If in a cell:

VB Code:

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

hi zaza...

Thanx 4 that..Its worked for me..thanQ.

Glad to have helped. Don't forget to mark the thread as Resolved...