Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

In this lesson, I’m going to be showing you how to:

  1. Format cells as Currency (£) in Excel
  2. Apply 2 Decimal places to numbers in Excel

Go ahead, open the video below and watch the tutorial at your own pace:

Note: a NEW lesson 13 VIDEO is coming soon – sorry for the inconvenience

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Or go back to:

Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

30 thoughts on “Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?”

    • I agree with you Gareth. The knowledge of excel makes our lives so much easier and more efficient as it contains a lot of automated techniques and routines, which saves us time and improves on productivity.

      Habib (ICT Tutor)

  1. wow your tutorials are always good.
    I have been looking for ways to actually have an excel spreadsheet to do automated calculations and have struggled to know this.
    Your tutorials are what I will refer to when I need help. Thanx again Well written.

    • Thank you Thabo – automating spreadsheets is the way to go. Formatting cells and shading them too also gives you the visual appeal to it. Take care

      Habib (ICT Tutor)

  2. Hello Habib,
    I use Excel in my work so it is great to read your explanation about specific topics of excel.
    You refresh my mind with some information and you teach me new ideas. Your explanation is clear and interesting
    Wishing you great success

    • It is my pleasure Rani, you have completed many of my lessons and I can see you are learning a lot and enjoying them very much. That is my main aim of these lessons – I want everyone to be learning and I am offering these lessons for FREE. Take care

      Habib (ICT Tutor)

  3. Hi Habib,

    This is another very clear and practical post of you!
    It really makes Excel looks easy and fun to use. Wish your website was already there when I had to learn this back in high school…


  4. Hey Habib,

    You have some very useful tutorials and i love how simple and straight to the point they usually are. Knowing how to do the basics in Excel is so imperative in today’s world. i wish they taught this in school..but I am glad you are doing a great job!

    • Hi Sasha,

      Thank you for your reply and lovely comments. I try my best and want to make sure it’s as simple and easy for everyone to follow.

      Best Wishes

  5. Fantastic tutorial about ‘how to format cells as currencies’. I liked the way you explained this, and it was effortless to follow. I am happy I learned something new and the fact that this task will cost me less time in the future.
    Best wishes.

  6. Hello – great job in showing us how to format cells in pounds and decimal places. Your video is easy to follow and will help a lot. I look forward to seeing the next ones.
    Keep Well,
    Nancy Hamar

  7. Thank you so much for this informative lesson, Habib! I love Excel, and I regularly use both the currency and decimal place functions. I learned by trial and error, however; just bumming around until I finally struck gold. Haha I would have loved to have had your video back then! You do an excellent job of describing the process; even the newest of people to Excel can follow along and know what to do. I have saved your article, and will definitely share it with my friends and family! Great read! God bless you!

    • Thank you very much – explaining the basic sometimes is what we all need to understand the more complicated stuff as the basic gives you the strong foundation. I’m happy to hear you will share our site with your friends and family, so they can benefit too. Great stuff, take care.

      Habib (ICT Tutor)

  8. Hello Habib,
    Like you website it is very explisit, I use excel in another compagnie I work with and I like it very much. Good job for the video it help me with what I have to do at work.
    thank you for this video

  9. Excel is not one of my strengths I have to admit and I do not use it that often. Your lessons here are valuable and I will definitely save your website for further guidance.

    Great post.

    Joe Joson

    • Thank you Joe. Please do share them with your family and friends so everyone can benefits from these tutorials on Microsoft Excel.

      Best Regards
      Habib (ICT tutor)

  10. Interesting article for sure. I don’t have much experience with Excel but still found your article very helpful.

    Thanks for sharing.

  11. Thanks Habib for these helpful lessons on using Excel. I as a complete beginner to Excel, these videos have been a gold mine of knowledge.

  12. It’s so great to see such a brief yet educative tutorial. I personally find it hard sitting through long lessons and I enjoyed every bit of this delivery. It is clear that you are an expert in excel and I will certainly come back for more!

  13. Hi habib
    Thanks for this informative post. I usually do not use currencies in excel but it’s good to know in case of yearly budget planning

  14. Managing and graphing currency and profit is one of the main reasons I use excel so often. This is a very helpful video, and just like all your other videos, it helped me learn even more about excel.

    Thank you for sharing!

    • Hi Joseph,

      Many Thanks for your compliments and comments.
      I’m glad to hear my tutorials on Microsoft Excel have been useful for you.

      Best wishes
      Habib (ICT tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap