text: Formatting can also be applied as you type. For example, if you type***30/9/2020***Excel will place the 
  number***44104***in the cell but will format this number as a date and show it as you typed it. There are also 
  a range of number formatting options on the ribbon that allow you to apply formatting to numbers after 
  they have been entered into a worksheet. 