Date: | 16/05/2023 |
---|---|
Time: | 1:00 PM AEST |
Event: | FREE - Custom Number Formats |
Topic: | FREE - Excel Custom Number Formats |
Public: | Public |
Registration: | Click here to register. |
FREE – Custom Number Formats
In this webinar we examine Custom Number Formats which hide away at the bottom of the Number Format tab. These custom made formats offer some useful techniques.
They can
- display negatives in red and with brackets
- format mobile phone numbers correctly
- display numbers and text together and still perform calculations
- hide zeroes
- display rounded numbers to thousands and millions
- display the day of the week
- create customised dates
- be saved and be available in new sheets and files using a Template
- be saved as a Style
See examples and demonstrations of many different custom number formats and learn how to create your own.
As always I will share a few other tips.