Re: $$Excel-Macros$$ Re: How can Divide the Numbers by 1 lac in excel

2010-08-21 Thread Dilip Pandey
Quick solution!! Grt answer. Best Regards, DILIPandey On 8/20/10, Soni.Rajender wrote: > Hi OPS > > Simply write 1,0 in any cell, copy it, select the cell whom u want > to convert, right click --> select paste special, under paste option > select "values", In operation section select "d

RE: $$Excel-Macros$$ Re: How can Divide the Numbers by 1 lac in excel

2010-08-20 Thread MITTAL AJAY
AND VBA MACROS Subject: $$Excel-Macros$$ Re: How can Divide the Numbers by 1 lac in excel Hi OPS Simply write 1,0 in any cell, copy it, select the cell whom u want to convert, right click --> select paste special, under paste option select "values", In operation section select &q

$$Excel-Macros$$ Re: How can Divide the Numbers by 1 lac in excel

2010-08-20 Thread Soni.Rajender
Hi OPS Simply write 1,0 in any cell, copy it, select the cell whom u want to convert, right click --> select paste special, under paste option select "values", In operation section select "divide", click on ok. Regards Rajender Soni | 7503225550 On Aug 20, 8:53 am, OPSHARMA wrote: > Dear Ex

$$Excel-Macros$$ Re: How can Divide the Numbers by 1 lac in excel

2010-08-20 Thread Kishan Reddy, K
You can use the following OPERATORS in excel +addition, - substraction * multiplication / division for example if your data is in Column B1, Just Type this column C =B1/10 Your values in lacks will be available in column C If you want round it (Restrict the number of decim