Paste data in "Accounting"format from Excel into Word changes formatting

		Microsoft Office Forums > Microsoft Word > Word
Paste data in "Accounting"format from Excel into Word changes formatting

FAQ

Thread Tools

Display Modes

10-17-2012, 11:55 AM

cory_0101

Windows 7 64bit Paste data in "Accounting"format from Excel into Word changes formatting

Office 2010 32bit

Novice

Join Date: Sep 2012

Posts: 4

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
replace data from variable with "sub and super script" from excel to word by vba	krishnaoptif	Word VBA	9	06-22-2012 05:08 AM
How to edit the "Format" and the "show level" of an EXISTING table of content?	Jamal NUMAN	Word	2	08-14-2011 10:46 AM
Why the "table of contents" doesn't take the same format of the "headings"?	Jamal NUMAN	Word	5	06-15-2011 10:14 AM
How to use "if" to copy and paste data	tareq	Excel Programming	13	01-26-2011 03:34 PM
Saving only "DATA" on excel? No white bottom?	jrasche2003@yahoo.com	Excel	0	08-07-2006 09:27 AM