Create a custom format in Excel

Excel custom format 1

In the example above, I have a value of 347 in the C12 range. I would like to add “Units Sold” after the value. First I right click then click format cells. In the custom area, I type

0 “Units Sold”. The zero represents the value of the formula and anything I want after it needs to be in quotes.

Excel custom format

The output looks like the screenshot as shown below.

Excel custom format


About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at
This entry was posted in Excel and tagged . Bookmark the permalink.

Leave a Reply

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

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

Google+ photo

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

Connecting to %s