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

| Last updated: 15 February 2017

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
Daily Limit Reached

You have reached your daily limit of 2 Free Articles

Subscribe to CCI PRO for unlimited access

Why Upgrade to CCI PRO?
  • No Ads
  • WhatsApp Broadcasts
  • Daily E-Newsletter
  • Unlimited Articles Access
BEST VALUE
2 YEAR PLAN
3,499
(Inclusive of GST)
1 YEAR PLAN
1,999
(Inclusive of GST)
View all CCI PRO benfits

Already a PRO member? Login here for an ad-free experience.

24226 Views 5 Likes Comment   Share Students   Report


CA Rishabh Pugalia (ExcelNext)

About the Author

Trainer

/coaching/excel.asp

View Articles
Comments :

Related Articles


Loading


Popular Articles




Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Pro Member DHANASHRI KARMARKAR DHANASHRI KARMARKAR Pro Member KayOne ConsultingKayOne ConsultingPro Member AGNIHOTRAM RAM NARAYANAAGNIHOTRAM RAM NARAYANAPro Member NISHANT SIPANINISHANT SIPANIPro Member Amar HiroAmar Hiro
Subscribe to Pro
Join an elite circle of professionals

CCI Articles

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

submit article

Browse by Category