I create a report in excel with all the correct formatting. I used Excel custom formatting to add a space at the end of a positive number to allow aligning of digits in the column. In Excel, it looks good but once I embed the Excel name range into a Word doc, it drops the ending space and all the numbers are out of alignment. I dont want to have to manually format all the numbers in the word doclet.
The goal is to align the thousand separator comma so positive numbers have an extra space at the end to allow for the closing parenthesis for the negative numbers.
Custom format I'm using is _(#,##0_);_((#,##0);_("—"_);_(@_)