Fix Excel Accounting Currency Spacing When Copying to Word
Question details
Preserve the spacing and appearance of South African Rand amounts when copying an Excel Accounting-format range into 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.
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.
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.
In Excel, select the formatted cells and choose Home > Copy.
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.
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 range as an embedded Excel worksheet object
Use an embedded object when preserving Excel's cell formatting is more important than editing the data as a Word table.
Paste the Excel range as a picture
Use a picture when the visual layout matters more than editing individual cells.
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.

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.




