text: **Number Formatting – The*Veil*Placed Over Numbers**
  
  All calculations in Excel are performed using numbers – this is only logical. So, when you want to perform 
  a calculation, you type the numbers in various cells, then create formulas to reference those numbers. 
  How do you show what those numbers represent? For example, how do you show you are working with 
  *currency*, or*percentages*, or even*dates*(which in Excel are really*numbers*)? 
  Excel allows you to show these representations using***number formatting***. With number formatting you 
  change the way a number looks so that it makes immediate sense to the reader of your worksheet. The 
  underlying value of number, however, remains unchanged. For example, instead of showing sales tax in 
  a worksheet as***.1***you show it as***10%***, to show***12889.95***as currency it would appears***$12,889.95***or 
  €***12,889.95***(depending upon the currency you are working with), and to show***44104***as a date you show 
  it as***30-Sep-2020***(remember, dates are actually*numbers*representing the number of days from January 
  1, 1900). 
  The following worksheet contains formatted numbers: 