Learn all  about Microsoft Excel !   

Microsoft Excel  Do you need specific attention ?

Learn all  about  Outlook !  

Microsoft Outlook Do you need specific attention ?

Learn all  about Microsoft PowerPoint ! 

       

Microsoft Powerpoint  Do you need specific attention ?  

Learn all  about Power BI ! 

Microsoft Power bi   Do you need specific attention ?

     Learn all about Microsoft Access ! 

Microsoft Access  Do you need specific attention ?

How to add currency symbols to your excel tables or data! enjoy the free lessons Excel 2017

How to add currency symbols to your excel tables or data
Sometimes  you  may  need to  display  the  values  you have  as currency  which  means  for  each  value  you need to  add  a specific    currency  symbols.
For  that,  all what  you need to  do  is  changing  the  cells’  format  to "Currency" or  "Accounting".

Take  the below example: 

For  each  column we  need to change  the  cells format  to  currency  following the   titles  : if  the symbol  mentioned  in title is  “$” then  all  the  column’s  value  have  to be  expressed  in term  of  “$”.
The  result  we  are looking  for  is  passing from  table  1 to  table 2  by adding  currency  symbols:

To change  Cells’  format  you  need to  call  Group :  “Number “   and  select the  format  you need via  the drop down  list shown  as  you can see  below:


 
But before  you need to select  the  cells  you need to change. And for  our  example, the steps to follow  are :

  • Select the concerned cells : 






  • Select the currency you need, in this exemple is the USD  “$”: 












  • Once this is done, you will get this result:






There  is  another  way  to get  the same  result , and in order  to have  access  to this  option, you can  follow those  steps:


  • Select  the cells  you need  to make  changes.

  • Click  left  on your mouse’s button.

  • Select  “ Format  Cells: 








  • Select  “currency “ on category  and  choose  the  currency  you are  looking  for  on  “Symbol” as  below:


At  any time  you can  cancel  the currency format  and  set  back  the cells  as  they  were at first only   by  selecting  those cells  and  then  click on “General”  or  “Number”  always  from  Tab : Home – Group: Number.


Hope this article was useful, please don’t hesitate to leave comments or ask question if there is anything needs  more clarification.