Apply Currency Formatting

Display numbers as money with a currency symbol and two decimals.

You will learn to

• Apply a currency format without changing the value

How it works

Select the cells and choose the Currency or Accounting format (Home → Number). Formatting changes how values look, not the values themselves.