Formatting Issues

Fix Excel for Mac Adding Spaces When Copying Accounting Values

Rana Garcia Sep 25, 2026 869 views

Question details

Users need to copy numerical data from Excel into external text applications without unwanted padding spaces.

How to Fix Excel for Mac Adding Extra Spaces When Copying Accounting Values

Product: Excel for Mac
Device & OS: macOS Sonoma 15.0.1
Scenario: Copying cell values formatted as Accounting in Excel and pasting them into plain text editors like TextEdit.
Observed behavior: Excel automatically adds an ASCII space before and after the text when pasted into TextEdit, though it appears normal when pasted into another Excel cell.

Before you start

Ensure you have saved your spreadsheet before making formatting changes, as altering number formats will temporarily remove currency symbols and decimal alignments.

Solution 1Recommended

Change the Cell Format to Text

Converting the cell format to Text removes the alignment padding associated with the Accounting format, preventing extra spaces when pasting outside of Excel.

The Accounting number format in Excel is designed to line up currency symbols and decimal points perfectly within a column. To achieve this visual alignment, Excel inserts hidden padding spaces. When you copy these cells and paste them into a plain text editor like TextEdit, those alignment spaces are converted into actual ASCII spaces.

By changing the format to Text or General before copying, you strip away the formatting metadata, allowing you to copy the raw numerical value.

Select the affected cells

Highlight the specific cells or the entire column containing the Accounting values that you want to copy.

Open the Format Cells dialog

Right-click the selection and choose 'Format Cells', or press Command + 1 on your Mac keyboard.

Change the format to Text

Navigate to the 'Number' tab, select 'Text' (or 'General') from the Category list, and click 'OK'.

Copy and paste the values

Press Command + C to copy the newly formatted cells, open TextEdit, and press Command + V to paste. The values will now appear without extra spaces.

Alternative Copying Method: If you do not want to alter your original data's formatting, copy the Accounting cells, paste them into a blank column using 'Paste Special > Values', and then copy those plain values to TextEdit.

Easy Spreadsheet Formatting

Format and Copy Financial Data Cleanly with WPS Spreadsheet

WPS Office offers a highly compatible spreadsheet tool that makes managing financial formats, copying data, and pasting text to other applications effortless and precise.

1. Open your file in WPS: Launch WPS Spreadsheet and open your existing Excel workbook.
2. Highlight the data: Select the cells containing the financial data you wish to export.
3. Adjust the cell format: Right-click, choose 'Format Cells', and select 'Text' to remove alignment padding.
4. Copy without spaces: Copy the data and paste it seamlessly into any external text editor without unwanted spaces.

Easily switch between Accounting, Currency, and Text formats without data loss.Fully compatible with Microsoft Excel (.xlsx, .xls) file formats and formatting rules.Lightweight software with a familiar interface for quick onboarding.Free to use across Mac, Windows, iOS, and Android devices.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Currency format not add spaces like the Accounting format?

The Currency format places the currency symbol directly next to the number. The Accounting format, however, aligns the currency symbol to the far left of the cell and the numbers to the right, using hidden spaces to achieve perfect vertical alignment.

Can I permanently disable the padding spaces in the Accounting format?

No, the hidden padding is a fundamental characteristic of the Accounting format in Excel. If you do not want spaces, you must use the Currency, General, or Text formats instead.

Does this spacing issue happen when copying to Microsoft Word?

Generally, pasting into Word as a table or formatted text retains the Accounting alignment accurately without breaking the layout. The extra ASCII spaces usually only become visible when pasting as unformatted plain text into editors like TextEdit or Notepad.

Document & File Issues