Share this article...

You can change the way Microsoft Excel formats numbers so it is displayed as Currency

 Microsoft Excel

Excel - raw figures (unformatted)

Have you noticed if you type numbers into cells how it is actually displayed? This is known as the Format. Look at the figures on the right....

Display as Currency

Do you want your figures displayed as currency all correctly lined up? (In other words formatting the cells as currency)

1. Select the column you wish to display as currency (in the case click the letter A in the box at the top)

 

2. Look along the toolbar and click the Currency button - looks like this... Currency Button

That's it all done.

Tip: When you type figures into any cell in that column, there is no need to type a currency symbol. Nor do you need to type every decimal - e.g. Type 12 and it becomes £12.00, Type 10.2 and it becomes £10.20

Share this article...
Was this article helpful? Add your comment below...

Design Your Excel Training

checklist

Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 185

    Anne R has awarded Dominic a Virtual Cake because "it is Mike's birthay and we thought you might like...

  • Thanks No. 184

    Jean has awarded Dominic a Virtual Beer because "Thank you...

  • Thanks No. 183

    Nicky has awarded Dominic a Virtual Beer because...

  • Thanks No. 182

    Sarah at CSEL has awarded Dominic a Virtual Tea because "quick and efficient...

This website uses cookies to help us improve your experience.
By using our website you accept our Privacy Policy and use of cookies.