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
how can i fomat currncy format like this: 1.222,33
The sourceformat is : 1222,33
Thank you very much,
Reards Uwe
just put the formula in Cell B1 assuming your data is in aa =SUBSTITUTE(A1,".","")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i did not see the vbscript title, i thought in excel :)
Or try
response.write(FormatNumbe r(Replace( "1222,33," ,",".")))
response.write(FormatNumbe
Format(100000.91, "#,###.00")