HOW TO FORMAT LARGE NUMBERS INTO THOUSANDS, MILLIONS, BILLIONS, ETC IN EXCEL

HOW TO FORMAT LARGE NUMBERS INTO THOUSANDS, MILLIONS, BILLIONS, ETC IN EXCEL

Based on my experience, some executives prefer this kind of formatting especially when the presentation covers large accounting figures. This formatting makes it easy for your audience to read your numbers and comprehend differences. Example; Thousands 18,92273 becomes 18.9K or 19K Millions 2,192,324 becomes 2.2M or 2M I hope you spotted the significance. Pardon me if I didn't include some audios in this tutorial, I just made this over a MAN-COM meeting. I've included the formatting in the video so you all could easily follow the procedures by yourself.