Hi ,

With another year almost at an end I'd like to use this email to say thank you for being part of our community, and wish you a happy and healthy 2024.

I'd also like to thank our volunteer forum moderators Riny van Eekelen and Velouria for the time they spend helping people with their Excel problems.  

As do our other volunteer helpers Anders Sehlstedt and Hans Hallebeek.  Thank you all.

Another important member of our team we'd like to thank is Catalin, who answers questions in the forum, and replies to emails and blog comments, helping people with their issues.

With that, we’d like to wish you Merry Christmas and Happy New Year. We're taking a one week break from writing newsletters, YouTube videos and blogs.  See you in 2024!

✨Excel Number Formatting Secrets Cheat Sheet

Transform your spreadsheets from amateur to pro with Excel custom number formats.

Use custom number formats to:

• Hide values: negative, zero or all
• Leverage # and ? characters to handle how zeros are displayed and get perfect alignment
• Customize currency formats and add some color
• Scale values to thousands, millions, billions etc.
• Add trailing or leading characters when creating forms
• Manipulate dates and time to display them just the way you want
• Create custom formats for fractions & percentages
• Add text for units of measure like Km, Mi, Kg, Lb etc.
• Format long numbers like phone numbers with spaces, parentheses or hyphens
• Handle scientific notation like a pro

🔗 Download here: Custom Number Formatting Cheat Sheet

Super Shortcut

CTRL + SHIFT + ^

Apply scientific format

Mynda Treacy

Microsoft MVP

Co-Founder My Online Training Hub

This email may contain affiliate links. This means I may earn a commission should you choose to make a purchase using my link. But we only promote courses we believe will benefit you.