Get a FREE 2.4 hour Excel 2019 Beginners course here ►https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

During this Microsoft Excel 2016 training tutorial video, we will show you how modify numbers entered in a cell into various formats such as fractions, scientific, accounting, special, and time formats. We will also demonstrate how to format number as text, as well as how to edit contents and delete characters in a cell.

Checkout some of our other training on YouTube:

VBA for Excel tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hWRi0mgxdyWkT0QaYKuBGZ

Excel 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jUeMoLReqNzzuKj7rdLhZ2

Excel 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jVfCjoptJb_mimawnVezqh

Access 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gbtcZ9Z3kbhk-2v65bfGeX

Project 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i1QJ6-Z91KRjFg5dzacD1O

Visio 2013 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jpAwkTGD6hGNxF8ML_FfsF

SharePoint 2013 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jloGuvewOe0Iv1EE2POKge

PowerPoint 2013 training for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gX0kiJc3k8d31y0zTLcECq

Stay in touch:
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Facebook: https://www.facebook.com/SimonSezIT/

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)


Hello again and welcome back to our course on Excel 2016.
I’m starting this section with the Business Expenses workbook that I created in the previous section and I’m going to look first of all at some of the other available formats in Excel 2016. Then I’m going to turn my attention back to entering and editing data and point out some other very important things about that.

Now given that this is supposed to be an expenses sheet if I wanted to now start putting in the costs against the train fare York to London on Monday, March the 9th, I’m going to say that it was 127.50. So I’m going to put in 127.5. Now look what’s happened. Because I inadvertently had left a Date Format on that cell I come up with that really strange old date. So what I will normally need to do is to make sure either before I enter data or after enter data that I’ve selected the right sort of format.

Now if I had put 127.5 in the next one, well actually it’s the taxi fare so let’s not go too far. Let’s say 32.5. If I’d put that in that cell bear in mind that I haven’t formatted this cell as a Date Cell. It just stays as 32.5. 32.5, let’s look at what format has been assigned by Excel. It actually has assigned the General Format and it will very often assign the General Format. Now there are many number formats that can be applied to a cell with a number in it. So for instance I could assign a Fraction Format. Watch what happens if I apply the Fraction Format to that. I can choose the number of digits. I can choose whether I want it as say eighths or sixteenths or quarters. Supposing I wanted to do it as halves. Note the format isn’t applied until I click on OK and it becomes 32½.

Let’s format it again. This time I’m going to try Scientific Format. Note that I can choose the number of decimal places. Let’s stick with two decimal places. Click on OK and it becomes 3.25E+01. That’s 3.25 times 10 to the 1.

Let’s try another one. Now this time I’m going to apply a Counting Format. Notice that each time I change the category I have a different set of options on the right. So in the case of Accounting Format I can choose the number of decimal places and I can choose the symbol. If I were say a U.S. based accountant I may generally work in U.S. dollars but I may have clients around the world and for each client I would need to use the accounting symbols that are appropriate to that client.


Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.