• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Excel / How to Add a Dollar Sign in Excel for Office 365

How to Add a Dollar Sign in Excel for Office 365

March 19, 2019 By Matt Jacobs

There are many ways that you can customize a spreadsheet in Microsoft Excel. From options like adding a row to the top of every page when you print to centering data within your cells, you have tons of options available to you to make your spreadsheet look how you want.

But there are also ways that you can customize the appearance of your cell data in ways that can save you some hassle. One of these concerns monetary values. If your spreadsheet contains a lot of numbers and only some of them are money, then using the currency formatting and including a dollar sign in front of monetary values can be very helpful.

How to Automatically Add a Dollar Sign in Front of Numbers in Excel

The steps in this article were performed in the Excel for Office 365 version of the program. In this guide we will be selecting a column in a spreadsheet and changing the formatting option for it so that a dollar sign is placed in front of any values that you enter into that column. Once your data looks the way that you want, you might consider centering your spreadsheet so that it looks better when you print.

Step 1: Open your spreadsheet in Excel.

Step 2: Select the column letter that you wish to modify. This will select the entire column.

select the cells to format

Step 3: Click the Home tab at the top of the window.

click the home tab

Step 4: Click the $ button in the Number section of the ribbon.

how to add dollar sign in front of numbers in excel

Alternatively you can switch to currency formatting by right-click on the selected cells and choosing the Format Cells option.

right click then choose format cells

Then clicking the Currency option in the left column.

choose the currency format

Confirm that the settings are what you want, then click the OK button.

change currency format settings

Is your printed spreadsheet coming out on too many pages, some of which only include one or two columns? Find out how to fit all of your columns on one page when printing so that the data is easier to read.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

How to Enable Macros in Excel

How to Exit Full Screen in Google Chrome (Windows)

How Do I Force Microsoft Word to Start a New Page?

Where Are the Best of Three Constructed Modes in MTG Arena?

how to get emojis on an iphone 7

How to Get Emojis on the iPhone 7

how to turn wifi on or off on iPhone

How to Quickly Enable or Disable WiFi on an iPhone

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com