01-31-2007 5:06 PM
hi ,
i need amount in figures.
eg : 10.000.000,00(normal format) as 10,00,00,000.00(required format)
how to solve this help me out.
thanks.
01-31-2007 5:08 PM
Hi,
Try Set Country command after assigning values.
e.g.: SET COUNTRY 'US'.
Ashvender
01-31-2007 5:12 PM
01-31-2007 5:15 PM
Hi santhosh,
You gave me the link which does not suit my requirement.
kindly check it
01-31-2007 5:17 PM
Hi Pandiyan,
Have you tried Set Country command after assigning values.
e.g.: SET COUNTRY 'US'.
01-31-2007 5:16 PM
01-31-2007 5:19 PM
V1 = 10.000.000,00
replace ',' with ' ' into V1.
replace '.' with ',' into V1.
replace ' ' with '.' into V1.
01-31-2007 5:51 PM
hi
good
declare a character with ,.
store the value 10.000.000,00 in a variable and separate as per your requirement and concatenate" ," value with each and each value that you separate.
Thanks
mrutyun^