Formatting Issues

How to Reduce Space Between Dollar Sign and Amount in Excel

Maira Mehtab Sep 28, 2026 869 views

Question details

The user needs to remove the excessive blank space between the dollar sign ($) and the numerical amount in spreadsheet cells.

Product: Excel
Device & OS: not provided
Scenario: Copying and pasting monetary values from Excel into an email.
Observed behavior: The values contain large spaces between the currency symbol and the number, causing the text to wrap onto two lines inappropriately when pasted.

Before you start

Select the cells containing the monetary values you wish to modify before applying any formatting changes.

Solution 1Recommended

Change Cell Format from Accounting to Currency

Switching the number format from Accounting to Currency aligns the dollar sign right next to the number, eliminating extra spacing.

The 'Accounting' format is designed to align currency symbols and decimal points perfectly in a column, which naturally creates a wide gap between the symbol and the number. The 'Currency' format places the symbol directly adjacent to the amount, making it ideal for copying into other applications like email clients.

Select the Target Cells

Highlight the cells or columns containing the spaced-out dollar amounts that you want to fix.

Open the Format Cells Dialog

Right-click the selected cells and choose 'Format Cells' from the context menu, or press the 'Ctrl+1' shortcut on your keyboard.

Apply Currency Format

In the 'Number' tab, select 'Currency' from the Category list on the left. Choose your desired decimal places and click 'OK'.

Alternative Quick Ribbon Method

Alternatively, go to the 'Home' tab, locate the 'Number' group, click the dropdown menu (which likely says 'Accounting'), and select 'Currency'.

Ready for Email: Once the format is changed to Currency, pasting the values into an email will no longer result in line wrapping caused by the extra spaces.

Format Cells Easily with WPS Office

Easily Manage Currency Formats with WPS Office Spreadsheets

WPS Office provides a highly intuitive interface to quickly adjust cell formats, ensuring your financial data looks professional and copies flawlessly into emails or text documents without unwanted spacing.

1. Open your spreadsheet: Launch WPS Office and open your workbook containing the spaced-out financial data.
2. Select your data: Highlight the cells with the problematic currency values.
3. Change to Currency: Navigate to the Home tab, click the Number Format dropdown, and select 'Currency' instead of 'Accounting'.
4. Copy seamlessly: Copy the newly formatted cells and paste them perfectly into your email without any text wrapping.

100% compatible with Microsoft Excel (.xlsx) formatsQuickly toggle between Accounting and Currency formats to remove gapsFree and lightweight suite for PC, Mac, and mobilePrevents unwanted formatting issues when copying data to other apps

microsoft office alternative - wps office

Frequently Asked Questions

What is the exact difference between Accounting and Currency formats?

The Accounting format lines up the currency symbols and decimal points in a column, adding dynamic space between the symbol and the number depending on column width. The Currency format places the currency symbol directly next to the first digit of the number, without extra spacing.

Why do my numbers turn into hashtags (####) after changing the format?

This happens when the column is too narrow to display the newly formatted number. Simply double-click the boundary of the column header to auto-fit the width, and the numbers will display correctly.

Can I set 'Currency' as the default format when clicking the dollar sign icon?

By default, clicking the dollar sign icon in the ribbon applies the Accounting format. To apply the Currency format, you must select it from the Number Format dropdown menu or use the Format Cells dialog (Ctrl+1).

Will changing to Currency format affect my formulas or calculations?

No, changing the cell format only alters how the numbers are visually displayed. The underlying numerical value remains exactly the same, so your formulas will continue to calculate accurately.

Document & File Issues