Excel
This query is : Resolved
20 July 2013
hi sir
my cury is how can i sum of figurs including text like rs.50000, in excel.before asking i attemp a lot but couldn't be able to do so.
my cury is how can i sum of figurs including text like rs.50000, in excel.before asking i attemp a lot but couldn't be able to do so.
16 August 2013
DO NOT write "Rs" before the figure. Just write the figures. Then Format the Cell. Under the Number tab, Select currency. Then select Rs. symbol.
Now you can sum the figures. Select the same format for the sum cell also.
Now you can sum the figures. Select the same format for the sum cell also.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CPC Processing IT Return for AY 2023-24 without recognizing the Taxation Option under New Regime
- Applicability
- Is Aadhar PAN linking required for opening bank account?
- Where to show the RCM on Rent paid to unregistered landlord
- RCM - commercial rent paid to URP under GST
- Offsetting interest income against derivative trading losses
- Application of 115BAC
- GSTR-3B - Do I file nil when there is no sale but I've bought raw materials
- TDS NUMBER SURRENDER
- Legal heir raised refund , but refund issued to the closed account of deceased.
- Capital gain on flat sale by nri, rate is 12.5% wo indexation or 20% with indexation?
- Payable outstanding for years disallowance
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding Resignation by Auditor from Pvt. Ltd.
Trending Online Classes
-
Excel Mastery Program
CA Rishabh Pugalia
CAclubindia
