There is often a difference in the way your data appears in cells in Excel 2013 spreadsheets. The number of displayed decimal places can vary depending on the entered amounts so, if you are dealing with monetary values, it’s helpful to keep them consistent by formatting those values as currency.
But the default currency formatting in Excel 2013 includes a dollar sign in front of the numbers, which is something that you may not want. Luckily you have control over many aspects of the currency formatting, including whether or not that dollar sign is there. Our guide below will show you the option to adjust if you wish to remove that dollar sign from your currency-formatted cells.
How to Remove the Dollar Sign from Numbers in Excel 2013
The steps in this article will assume that the dollar sign is being added to your cell data due to an existing currency formatting setting. If the dollar signs have been entered manually, then adjusting the formatting in this manner may not work.
Step 1: Open your spreadsheet in Excel 2013.
Step 2: Select the cells containing the dollar sign formatting that you want to remove. You can select an entire column by clicking the column row letter, or an enter row by clicking the column row number.
Step 3: Right-click on one of the selected cells, then choose the Format Cells option.
Step 4: Click the Currency option in the column at the left side of the window, click the Symbol dropdown menu and select the None option, then click the OK button at the bottom of the window.
Have you downloaded a bunch of CSV files that you need to combine into one file, but copying and pasting all of that data will be tedious? Learn about a simple way to quickly combine multiple CSV files using the command prompt.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.