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 Threads
- Excess Payment on RCM
- AOC4 auto population of previous year data
- Exports against INR PO payable by Domestic Company
- Which websites are best for government exam prepar
- TDS on maturity payment of LIC of india
- ITR2 Gold ETF short and long term
- Query under faceless assessment
- Purchase of business
- Refund of ITC for advance paid to overseas supplie
- Clubbing query (when gifts given to multiple fami
Related Threads
CAclubindia
