Formatting Issues

Fix Excel Accounting Currency Spacing When Copying to Word

Khadija KhanKhadija Khan Nov 22, 2026 868 views

Question details

Preserve the spacing and appearance of South African Rand amounts when copying an Excel Accounting-format range into Word.

Fix Excel Accounting Currency Spacing When Copying to Word
Product
Microsoft Excel and Microsoft Word
Device & OS
not provided
Scenario
The user copies a range formatted with Excel's Accounting number format into a Word document.
Observed behavior
In Word, the Rand symbol appears directly beside the amount instead of retaining the spacing shown in Excel.
Before you start

In Excel, select a cell in the source range and open Format Cells to confirm that it uses the Accounting format and the intended Rand symbol. Note how you normally paste into Word and whether Office, the operating system, or the workbook changed before the spacing issue began.

Solution 1Recommended

Paste the Excel range into Word with source formatting

Try this first if you want the pasted data to remain a Word table.

Excel's Accounting format aligns currency symbols and values within cells; it does not necessarily insert literal spaces. A Word table may display that alignment differently.

1
Copy the range

In Excel, select the formatted cells and choose Home > Copy.

2
Keep source formatting

In Word, place the cursor where the range should appear. Open the Home > Paste drop-down and choose Keep Source Formatting if it is available.

3
Check the layout

Compare the pasted table with Excel. If the symbol or amount is still misaligned, adjust the Word table's column widths or try embedding the range.

Paste the Excel range into Word with source formatting
Free Microsoft Office alternative

Work with currency tables in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and documents. Open existing Office files to make migration easier, though it does not fix Microsoft Office's paste behavior.

Work with currency-formatted spreadsheet data in WPS Spreadsheet.Open and edit Microsoft Excel XLSX and Word DOCX files.Use a familiar interface for spreadsheet and document tasks.Move between spreadsheet and document work in one office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Rand symbol move next to the amount in Word?

Excel's Accounting format aligns the symbol and amount within a cell rather than relying on ordinary spaces. When the range becomes a Word table, that alignment may not transfer exactly.

How can I keep the copied cells editable in Word?

Try Home > Paste > Keep Source Formatting to create a Word table. If Excel-style formatting is more important, use Home > Paste > Paste Special and select Microsoft Excel Worksheet Object when available.

Which paste option preserves the exact appearance?

In Word, choose Home > Paste > Paste Special and select an available Picture option. The result is an image, so you cannot edit individual values as cells.

Will an embedded Excel object update when the original workbook changes?

No. An embedded object is a copy stored in the Word document. Double-click it in Word to edit the embedded worksheet content.