Forum Discussion
Embedding Excel into Word
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...
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.)
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.
A couple of ideas, then.
- I know Word allows for some formal alignment variations; not sure whether there's one around decimal (as opposed to the thousands separating comma). You might ask on the Word equivalent to this Excel forum.
- How about embedding the Excel section in the Word document as an image rather than as "live" data? Especially if whatever the document is, it ends up in PDF rather than as a "live"--editable--Word doc, that might be a way around the issue, if none other can be found.
