|Date:||September 28, 2021|
|Time:||1:00 PM AEST|
|Event:||FREE - Custom Number Formats|
|Topic:||FREE - Excel Custom Number Formats|
|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.
- 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.