Tricks to Format cells in Excel: Currency Format (Prefix)

CA Rishabh Pugalia (ExcelNext) , Last updated: 15 February 2017  
  Share

I have a large record set of the amount. I want toadd prefix i.e. Rs. in my records so that I can apply sum, average, min, max function. I can easily do it by typing it manually but then I will not be able to apply any function. If I enter any amount in this column I will need to add Rs. prefix m

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 2999/-

Offer Price : INR 1999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)
CCI Pro

Published by

CA Rishabh Pugalia (ExcelNext)
(Trainer)
Category Students   Report

Other Articles  
Comment   Share
5 Likes   24031 Views
Comments

Related Articles


Loading


Popular Articles





Meet our PRO Members
Subscribe to CAclubIndia Pro

Trending Online Classes

view all classess
Follow us

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category