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
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
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
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