Lesson 13: How to Format cells as Currency, Date, Percentages and apply 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. Format cells as Accountancy (£) in Excel
  3. Format cells as Percentages in Excel
  4. Format cells as Dates in Excel
  5. Apply Decimal places to numbers in Excel

Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.

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

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: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

32 thoughts on “Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel”

    • Welcome on board! I really hope there is all the information you need to be learning more about Excel. Please let us know if there is something I’ve not covered and you would like to learn.

      Many thanks for your feedback.

      Habib (ICT Tutor)

    • 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