• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Custom Format in Excel

July 23, 2021 by Andrew Childress
Custom formats in Excel

Excel includes an array of cell formats that you can apply to your worksheets. Let’s learn how to custom format in Excel.

Excel includes an array of cell formats that you can apply to your worksheets. Most of these are pre-built options that work great for many applications. But on occasion, you’ll need a very specific format that may not be included by default. Fortunately, this is easy to arrange in Excel. Let’s learn how to custom format in Excel.

How to Custom Format in Excel

Custom formats, like other formats, exist in the Format Cells menu. They can be applied to one or more cells in your Excel sheets. Formats tell Excel how to display given values. Changing a format or applying a custom design won’t actually change the value or values.

To add custom formats, begin by clicking into a cell in your worksheet where you have – or want to add – data to display. With the cell selected, right-click inside it. Then, from the dropdown, choose Format Cells.

Custom format in Excel

Excel will launch the Format Cells window. Make sure you’re working on the Number tab here. Then, from the Category list, click on Custom to select it.

You’ll see an array of preset options which control how values will be formatted and displayed. These may specify decimal places, time and date formats, and countless other options. Think of the presets as starting points for your data. In the Type box, you can also add your own custom format text. Start it from scratch, or begin with a preset and modify it.

Custom formats in Excel

For example, click on 0.00% in the Type box, and change it to 0.000%. Then, click OK. In the newly-formatted cell, type in 5.65089. Excel will automatically apply the formatting, rounding your value down to display as 5.651%.

How to custom format in Excel

As you can see, custom formats in Excel give you precise control over how data values are displayed on your spreadsheets.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to use countifs in ExcelCOUNTIFS Function in Excel
Next Post:How to Align Text in ExcelText alignment in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top