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 Topic
- Clarification Needed: Reporting Accrued vs Paid FD
- TDS on prize given to participants in Livestock sh
- TDS related matter - 194 IA
- Research: How do CA firms handle GSTR-2B reconcili
- CA FINAL FR IndAS 33 Illustrtion 14
- Taxation on Sale of old Jewellery Received at Marr
- ITR-3 Filling issues
- PF withdrawal and tax liability
- Sale of Goods or Services?
- ITR form query
Related Topics
CAclubindia
