Link to home
Start Free TrialLog in
Avatar of bounty457
bounty457

asked on

How can i format currency in vb script

Hello,

how can i fomat currncy format like this: 1.222,33
The sourceformat is : 1222,33

Thank you very much,
Reards Uwe
Avatar of Professor J
Professor J

just put the formula in Cell B1 assuming your data is in aa  =SUBSTITUTE(A1,".","")
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i did not see the vbscript title, i thought in excel :)
Or try

response.write(FormatNumber(Replace("1222,33,",",".")))
Format(100000.91, "#,###.00")