Paste data in "Accounting"format from Excel into Word changes formatting
I have a table of cells in Excel document that I change to "Accounting" format, when I copy and paste into a Word doc the "$" gets put on its own row and the only way to fix is to adjust the columns width. Any ideas what causes this and if there is a way to fix it. This formatting issue only occurs with the "Accounting" format.
Excel Column:
$ 4.00
$ 6.00
Shows up in Word like this:
$
4.00
$
6.00
|