Re: $$Excel-Macros$$ how to sum currency

2010-03-05 Thread Abhishek Jain
Dear Vikas, To come up with a possible solution to your query, I had to alter an UDF (User Defined Function) that was available on Internet (thanks to the original programmer). Here's what it will do: *It would check the number format (or currency format, you may wish to say) of the cell you pro

Re: $$Excel-Macros$$ how to sum currency

2010-03-05 Thread rf1234 rf1234
Hello Dear, First Perform the operation required(+,-,*,/ or %) what ever, then select the range go to cell formatting,currency,and symbole. Hope it will help Happy To Help :) Shyam On Fri, Mar 5, 2010 at 12:49 PM, Vikas Chouhan wrote: > > > Dear All, >> >> (i am using 2003 office) >> >>

Re: $$Excel-Macros$$ how to sum currency

2010-03-05 Thread Abhishek Jain
Dear Vikas, An example file would help to understand better. Please provide. Regards, On Fri, Mar 5, 2010 at 12:49 PM, Vikas Chouhan wrote: > > > Dear All, >> >> (i am using 2003 office) >> >> >> if multiply currency (exp. Doller,Rupees,Catalan,Finnish,euro) in one >> column (a1:a10) how i get

$$Excel-Macros$$ how to sum currency

2010-03-05 Thread Vikas Chouhan
Dear All, > > (i am using 2003 office) > > > if multiply currency (exp. Doller,Rupees,Catalan,Finnish,euro) in one > column (a1:a10) how i get the sum doller, rupees or more currency in > different column > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask.