Suggestion: Adding a button for number formats in thousand/million/billion in #Excel

Did you know what you may submit your ideas to improve Excel through UserVoice?

The recent HOT news in the Excel community – the new XLOOKUP function is also resulted from an idea submitted in UserVoice.

While everyone is super exciting about the XLOOKUP function, I would like to suggest a minor thing that is very basic but super helpful to most all Excel users.

My humble suggestion:

Adding a button for number formats in thousand/million/billion

Number Units_v1

Why have I come up with this idea?

Long time ago, I wrote a post Show number in thousand (k) or in million (M) by using custom format, which to my surprise, have become one of the top 3 posts in my blog.  It reflects the truth that it is a very common demand from Excel users.  Although it is not really “difficult” to use the custom format to solve the problem, it is not obvious nor intuitive for sure.

Then I searched the UserVoice to see if anyone has the same idea.  Of course, there is.  I came across the idea submitted HERE.  I VOTED for that immediately and left my additional suggestions in comments.  However, the number of VOTE is surprisingly low (only 28 votes including mine).

So, if you like the idea, may I ask you to VOTE for it!  And more importantly, spread the word to invite more votes.  Every VOTE counts.  Sometimes, a tiny change would make a big difference.  🙂





About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in General and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.