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
1 Replies
@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!!
Recent Topics
- Share office desk in bkc, near family court
- 80D claim for payment paid by parent
- TDS on purchase of Flat under subvention scheme be
- Nznxnc call me at the end of the day of the
- Nsje snswk fjw ed le ene djff ne enje ejdd rejje
- Hxjcif the day I have been in touch with me and
- Iska djd djrbdsjebshe sir ur rei ejr reinr the jr
- GST registration for medical shop in Karnataka
- Hsshs me know if you are free number of the
- Chu Kang and the situation of the situation and I
Related Threads
CAclubindia
