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.

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.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
21 August 2026
Accountant

A G International

Kolkata

B.Com

View Details
Company
ARTICLESHIP 26 August 2026
Article Assistant

ANIVESH CONSULTANTS LLP

Gurgaon

CA Inter

View Details
Company
28 August 2026
Assistant Manager

NRS AND ASSOCIATES

Kozhikode

CA Inter

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
16 September 2026
Internal Audit - Team Lead

Consulting & Beyond

Chennai

CA

View Details
Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
24 August 2026
Semi-Qualified CA/CA Finalist - Tax, GST, Audit & Accounts

Bharat Shah & Associates

Mumbai

CA Inter

View Details