Share via

Copying Excell Accounting format into Word

Anonymous
2018-01-30T08:58:00+00:00

I make pricing overviews in Excel and copy them into Word documents where I make offer/quote letters.

In Excel I always use the accounting format which, until recently, always went perfectly into Word. Simply copy and paste.

It lined up the currency symbol and the decimal points which looks decent.

Suddenly this doesn't happen anymore, now all prices have the currency symbol with one space in front of it.

I can't find in Word, Office help or the internet how to get it back the way it was.

This is my daily job and it's quite time consuming lining everything up manually.

How can I get it working again?

I work with Office 365 ProPlus

Version 1705 (Build 8201.2102)

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-01-31T14:39:48+00:00

Hi Mbe-nl,

Based on our test, we can reproduce the problem on our side with the same version, even if we use "Merge Formatting". But in the latest version, if you follow the same steps, you will get the expected result.

So we suggest you wait for the next update, the problem is fixed in the latest version.

While at present, you can use Keep Text Only to paste the data as a workaround.

Regards,

Tisky

Was this answer helpful?

1 person found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-01-31T06:53:40+00:00

    Hi Doug,

    tried it but alas it did not work.

    Thanks for replying.

    Was this answer helpful?

    0 comments
  2. Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
    2018-01-31T06:20:49+00:00

    In Word, go to File>Options>Advanced>Cut, copy and paste and from dropdown for Pasting from other programs, select "Merge Formatting"

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-01-30T13:44:47+00:00

    Hi Tisky,

    thanks for replying.

    First of all I work for a huge multi-national so our software is tightly controlled.

    This means I can't update Office myself and if I look at my Office account it says "This product will not be updated".

    I imagine my employer has turned off automatic updates en will push updates every now and then to my system.

    1. Yes the problem is now between Excel and Word with any Excel en Word documents.

        Pasting into an Outlook email has the same result.

    1. Here's an example of the Excel source and Word result side by side.

        I used completely blank files instead of the normal templates I use daily. (same result)

    1. As stated the software is all tightly controlled by my employer.

        I also do this every day the same way. I cannot imagine what I could have done to suddenly change this. (This doesn't exclude the possibility I'm the cause ;) but it seems unlikely)

    I've checked and there have been updates installed for office.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-01-30T13:11:17+00:00

    Hi Mbe-nl,

    Based on the information you provided, the version of Office applications are not the latest. Please update to the latest one to check whether the problem still persists.

    If the problem persists, we'd like to confirm more information.

    1. Does this problem influence all the similar files you have?
    2. Please provide the screenshot of the symptom, to protect your privacy, you may create a test file if the problem happens to all the files you have.
    3. Before you encounter the problem, have you done any changes?

    Regards,

    Tisky

    Was this answer helpful?

    0 comments