Applying number formats in Microsoft Excel 2019

It is possible to change the appearance of values in a cell withoutaffecting the actual value itself. Number formats are applied to valuesafter the number has been entered into the cell. For instance, if Ienter an amount of £4500.00 into a cell, I will not includethe £ symbol to indicate Pound Sterling.

The £ currency number format is applied to the cellsafterward. This is extremely important if you are going to becalculating in Excel or constructing any formula, as Excel will not knowhow to calculate values if a letter is included in front of the value.If you are unsure at any time, look in the Formula Bar below the ribbon,as this will display the actual cell content.

There are numerous options available to format data in Excel, some ofwhich are located on the Number groupof the Home tab. For more options, usethe dialog box launcher to visit the NumberFormat dialog box.

  1. Select the cells to apply a number format.
  2. Locate the Number group on theHome tab.
  3. Click on the drop-down list to the right of General.
  4. Choose a format such as Currency. A preview of each type isdisplayed under each format. For access to more options, click on More Number Formats… at the bottom of thelist to launch the dialog box.
  5. Once the number format has been applied, you may notice ##### instead of values in a cell—this isbecause the column is not wide enough to accommodate the values. Thiscan be seen in the following screenshot:
ms office 417
  1. To fix this, simply widen the column to display the values.

Leave a Comment