Add emoji to your numbers 😁 in #Excel

Is it possible in #Excel? Of course, as you have just seen it! 😁

Indeed, it’s easier than you may have thought about. We can do it by custom format.

First of all, select the cells that you want to apply custom format and then right click…

or simply press Ctrl+1 to open the Format Cells dialog box:

Copy the following string to the “Type:” of Custom Format (3 as shown above)

[Color10]😁* +0.0%;[Red]😭* -0.0%

Note: There is a space after the *, which is intentionally put there.

The *space portion is used to filling the gap between the emoji and the +/- sign using space that is responsive to the column width. Do not understand what I am talking about? πŸ˜…

No worries. Let’s watch it in action:

When the following string (without *space) is used:

[Color10]😁+0.0%;[Red]😭-0.0%

When the following string (with *space) is used:

[Color10]😁* +0.0%;[Red]😭* -0.0%

See the difference?

That’s cool 😎to add emojis to your spreadsheets… only when you are working with a company / team that thinks it is cool. Otherwise, it’s better to use something boring professional:

Here are custom format strings for your reference:

[Green]β–²* 0.0%;[Red]β–Ό* 0.0% 
[Green]↑* 0.0%;[Red]↓* 0.0%
[Green]+* 0.0%;[Red]-* 0.0%

Feel free to change the symbols for ups and downs.

Wait… how can I insert those symbols ▲▼↑↓ ?

Take a look at this blogpost: Input special characters in Excel by pressing Alt + Numpad

How about the emojis?

Press the Window and Dot keys together πŸ™Œ (applicable to Win 10)

Want more about custom format?

Take a look at this blogpost: Display descriptive words instead of numbers with Custom Format in #Excel

Do you have out-of-the-box usage of custom formats? Please share with us by leaving comments below. πŸ˜‰

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 Excel Tips, Format and tagged . Bookmark the permalink.

2 Responses to Add emoji to your numbers 😁 in #Excel

  1. NICK BUYER says:

    what colors are available to us? I see green and red. I changed green to blue because green was too bright. Initially I wanted “dark green” but got an error… Is there a list of allowable colors?

    Like

Leave a Reply to MF Cancel reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

You are commenting using your Twitter 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.