Custom number formatting doesn't work when pasted in Word

[Stidd]

I've been pasting linked Excel ranges into a Word document for presentation.
In Excel, I've created a custom number format so that negative numbers have brackets but remain aligned with positive ones i.e. "#,##0.00_);(#,##0.00)". However, no matter what type of link or styling option I use, this custom format is not carried over into the Word document. Some other elements are but not the trailing space for the ) symbol.
I have found a page which describes how to create custom formats in Word (Formatting Currency (Microsoft Word)) but I can't make it work in Word 2013 and it doesn't meet my needs as I need the numbers linked to the Excel, not manually typed in.
Is there any way to achieve what I want? I'd appreciate any guidance.
Thanks in advance

 

[Stidd]

I'm sorry oldbrewer but I really don't know what you mean. I must be missing something.

[TABLE="width: 640"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl24, align: right"](3.99)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl26"](3.99)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5.79[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl25, align: right"]5.79[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]forumformatting makes it look wrong but decimal points are lined up
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]the 5.79 is formatted 0.00# where # = a space character[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

have u tried my suggestion

 

[Stidd]

I'm really sorry oldbrewer but I can't follow your suggestion. If you have the time, it would be great if you could try re-iterating it but please don't feel obliged.

 

[oldbrewer]

the 5.79 is formatted 0.00# where # = a space character

use custom format for the positive numbers and type in the box 0.00 FOLLOWED BY A SPACE CHARACTER
THE NEGATIVE NUMBERS AND POSITIVE NUMBERS WILL NOW LINE UP BY THE DECIMAL POINT

 

[Stidd]

I've tried it but the numbers do not align on the decimal. They are close but the space after the positive numbers is not big enough to move the decimal to the left as much as a ). Two spaces is too much. That's why I used the _ character, followed by the ), which as I understand it, creates a space the width of the whichever character follows the _.

To be clear, this works for me in Excel. It is just that this particular piece of the custom number format doesn't follow into Word, whichever type of paste of link you use, except as a picture.