Best Offer for Books in Amazon

Showing posts with label How to Set 'Currency Symbol' to Values in Excel Data. Show all posts
Showing posts with label How to Set 'Currency Symbol' to Values in Excel Data. Show all posts

Tuesday 23 May 2017

How to Set Currency Symbol to Values in Excel Data

How to Set 'Currency Symbol' to Values in Excel Data

Hi...Reader.!

         Worrying about adding currency symbols for values in excel data. Don't worry in this lesson we will show you how to add currency symbols before a numeric value in excel data. So for this we just create a small database table in excel like below














as of show above prepare a table about employee salaries now,

1. select a column D here salary of employees
2. Home tab -> Accounting -> click '$' button -> set currency Style ($, Rs..)
3. Now watch your table it shows $ Symbol before employees salary amount.


Thank you
Excel Trics blog

How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.