How to Display a Figure Dash After a Dollar Sign in Excel
Question details
The user wants to format currency data by inserting a figure dash between the dollar sign and the price value without altering the actual data.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Customizing the visual presentation of pricing or financial data to meet specific stylistic requirements.
- Observed behavior
- The goal is to show a visual dash right after the currency symbol while keeping the cell's underlying data purely numeric so that calculations are not affected.
Ensure your target cells contain purely numeric values rather than text. If your prices are stored as text, custom number formatting will not apply correctly to the cells.
Apply a Custom Number Format
Use Excel's custom formatting feature to visually insert a dash without altering the cell's actual numerical data.
By modifying the Custom Number Format code, you can dictate exactly how Excel displays numbers, text, and symbols in a cell. Wrapping the dollar sign and dash in quotation marks tells Excel to display them as static text strings preceding your numerical value.
Highlight the column, row, or specific cells containing the prices you want to format.
Press the "Ctrl + 1" keyboard shortcut (or right-click the selected cells and choose "Format Cells") to open the formatting menu.
Navigate to the "Number" tab and select "Custom" from the category list on the left. In the "Type" input box, enter the format code "$‒"#,##0.00. Click "OK" to apply the changes.
Easily Format Currency with WPS Spreadsheet
WPS Office provides a robust, highly compatible Spreadsheet tool that handles complex custom number formats, including inserting dashes into currency symbols, exactly like Microsoft Excel.
- 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your spreadsheet file containing the pricing data.
- 2. Select the data and open Format Cells: Highlight the cells you wish to format, right-click, and choose "Format Cells" or simply press "Ctrl + 1".
- 3. Enter the custom format code: Go to the "Custom" category under the Number tab, input "$‒"#,##0.00 in the type field, and click OK to apply the formatting seamlessly.
Frequently Asked Questions
Will adding a dash after the dollar sign affect my spreadsheet formulas?
No, as long as you use custom number formatting (like "$‒"#,##0.00), the dash is only applied visually. The underlying cell value remains a pure number, meaning all your SUM, AVERAGE, and other mathematical formulas will continue to calculate perfectly.
How do I type a figure dash or en-dash on my keyboard?
You can type an en-dash by holding down the Alt key and typing 0150 on your numeric keypad. For an em-dash, use Alt + 0151. If your keyboard lacks a numeric keypad, you can copy the dash character from a text editor or the web and paste it directly into the Custom Format type box.
Can I add a space between the dash and the numerical price?
Yes. To add a space, simply include a space character inside your custom format code after the dash. For example, entering "$‒ "#,##0.00 in the Custom formatting box will display a dollar sign, a dash, a space, and then the numeric value.
Why is my custom format showing as text instead of a formatted number?
This usually happens if the cell was originally formatted as "Text" before you entered the number. To fix this, change the cell format to "General" or your new custom format, double-click the cell to enter edit mode, and press Enter to refresh the value as a readable number.
