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
CA Atihash Agarwal (CHARTERED ACCOUNTANT) (187 Points)
05 March 2013Sir,
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
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 05 March 2013
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!!
Live class on PF & ESI Enrollment & Returns Filing(with recording)
CAclubindia
