Tuesday, 5 February 2013

Excel: How to show number in custom format

You are able to format Excel's cell items as you like. You can e.g. add custom texts to be shown with numbers. Typical case is to show numbers with units:
  1. Select the cell/cells you want to format:
    Context menu: Select Format Cells
    Shortcut: Windows ctrl + 1, Mac cmd + 1
  2. Select Number and Custom from the Category list.
  3. If you want to one decimal and unit, type following format code
    0.0" kg" or
    0.0" lb"
Following video demonstrates this in action:

No comments:

Post a Comment