Number Formatting – Currency, Dates, etc.

DESCRIPTION: When presenting information, you do not want to give any more or any less than the reader needs. Don’t show a number with 10 decimal places when 1 will do. Don’t provide time stamps and year in your dates when you only need the day and month. These slight modifications will not only reduce the amount of visual data that your audience needs to process, but also compresses the appearance of your information. This makes it easier to absorb by the audience and increases the effectiveness of your presentation.

TARGET AUDIENCE: This is for beginners who are now quite confident with dealing with data and creating tables.




  • Applying currency, accounting, time, percentage, date formatting as well as several others
  • Custom data types using short codes
  • Format Painter for quick format duplication