How do I...
Show numbers as currency, percent or a date
What to do
- Select the cells.
- Press Ctrl+1.
- On the Number tab, choose Currency, Percentage, Date or another type.
- Click OK.
Good to know
- This changes how a value looks, not the value itself.
- The Home tab has quick buttons for $, % and decimal places.
The idea in general
The number stays the same underneath, and only its appearance changes.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.