VB FORMAT FUNCTION
-
hi frds... i do lot's of effort to do this but i was unable to do... my problem is that i have a number filed say amount in that the value store is 123456789.123 i want to show this value in indian currency format like 12,34,56,789.123 i also change the regional setting from control panel i do lot's of try but i was unable to this can u help me its urgent... also mail me on pankaj.indore@gmail.com:~ Regards Pankaj Joshi
-
hi frds... i do lot's of effort to do this but i was unable to do... my problem is that i have a number filed say amount in that the value store is 123456789.123 i want to show this value in indian currency format like 12,34,56,789.123 i also change the regional setting from control panel i do lot's of try but i was unable to this can u help me its urgent... also mail me on pankaj.indore@gmail.com:~ Regards Pankaj Joshi
-
Dim amount As Double = 123456789.123 MsgBox(amount.ToString("##,##,##,###.###")) Mike Lasseter
hello sir... thx for u r reply sir u gave code it is in Vb.net i want to do it in VB 6 plz help me... hi i am pankaj
-
hello sir... thx for u r reply sir u gave code it is in Vb.net i want to do it in VB 6 plz help me... hi i am pankaj
pankaj.indore wrote:
hello sir... thx for u r reply sir u gave code it is in Vb.net i want to do it in VB 6 plz help me...
Mike gave you the code - regardless of its origin you should be able to work this out yourself. BTW soliciting a direct email response by placing your email address in the forum is a BAD idea. Also, it may be urgent to you but don't put the pressure on the other forum members. We all have our own 'urgent' problems :-)
...Steve1. quod erat demonstrandum 2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once :-) -
pankaj.indore wrote:
hello sir... thx for u r reply sir u gave code it is in Vb.net i want to do it in VB 6 plz help me...
Mike gave you the code - regardless of its origin you should be able to work this out yourself. BTW soliciting a direct email response by placing your email address in the forum is a BAD idea. Also, it may be urgent to you but don't put the pressure on the other forum members. We all have our own 'urgent' problems :-)
...Steve1. quod erat demonstrandum 2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once :-)ok sir... i sorry for that hi i am pankaj
-
ok sir... i sorry for that hi i am pankaj
-
It is very similar Dim test As Double test = 111000111.235 MsgBox (Format(test, "###,###,###.##0"))
thx for u r reply sir.. but my problem is still not solved... i want to do this in indian currency format like 123456789.123 becomes 12,34,56,789.123 in india can anybody help me..? hi i am pankaj
-
thx for u r reply sir.. but my problem is still not solved... i want to do this in indian currency format like 123456789.123 becomes 12,34,56,789.123 in india can anybody help me..? hi i am pankaj
-
thx for u r reply sir.. but my problem is still not solved... i want to do this in indian currency format like 123456789.123 becomes 12,34,56,789.123 in india can anybody help me..? hi i am pankaj
Ever heard of the expression "RTFM" ? Here's a reference for you. Enjoy :) Definition of RTFM for those who cannot be bothered to do even some elementry research themselves [^]
...Steve1. quod erat demonstrandum 2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once :-)