Sir,
I have my CMA data sheet. The figures are in Rupees.
I want to convert the whole sheet into Rs in lakhs without affecting the formulas.
Is there any way? Kindly Advise
Menu
Excel query
Replies (1)
HI
You can do with paste special..
Type 100000 in one cell, copy that cell & do paste special on the cells which you want to divide by lac..
After you get paste spl window under operation frame select Divide...
You have to do this on cells which doesnt have formula..
Thanks!!
Recent Topics :
- Need formats of FS as per Co act 2013 in soft copy
- Remittance to italy
- Invoice made but goods not sent
- How Do CA Firms Manage Client Document Collection
- How do CA firms manage pending client documents du
- How to find a good CA
- Rcm on rent paid
- Clarify on GST Application
- Residential status for overseas students visitin
- Capital Gains Tax
Related Topics :
CAclubindia
