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
- Sales return eway bill
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
