Feb 10 2021 07:07 AM
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.
Feb 10 2021 07:53 AM
In this day and age where color printers are ubiquitous, why not display negative numbers in red.
(That would obviate the need to allow for parentheses altogether.)
Feb 10 2021 07:57 AM
@mathetes Because the US government is not that creative and do not need to see color. They do need to see it in a very boring black and white format with all the numbers aligned.
Feb 10 2021 08:08 AM
A couple of ideas, then.