Format numbers in a sheet

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

By applying different number formats, you can display numbers as percentages, dates, currency, and so on.

  1. Select the cells that you want to format.

  2. On the Home tab, under Number, click the formatting option that you want on the pop-up menu.

See also

Display dates, times, currency, fractions, or percentages

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.