Quote:
Originally Posted by Pecoflyer
- In Excel options - Advanced - Is Automatically add an insertion point checked or unchecked?
In my sheet it is unchecked and copy paste works perfectly
|
It is unchecked on my PC. I haven't had time to check where that option is on my Mac (which is where I will be using this data file). I have not been able to copy the data and paste it so that it shows up in the destination as it does in the spreadsheet.
Quote:
Originally Posted by Pecoflyer
If I understand correctly, the values in your table are the result of a calculation?
Why not adapt this calculation to show the desired number of decimals ?
|
The values are from a client supplied spreadsheet, and are not from a calculation.
I will be setting up couple of worksheets to do lookups from their data to organize it into the order that will be needed for the various views I will need, so I could probably add it to those lookup formulas, but those lookups/calculations may be complex enough without having to include the formatting in the calculated formula. Some of the columns of data need to be formatted to 2 decimals, others to 1. In all cases, the decimal should be removed based on the formula I was using for the conditional formatting.
I was happy that I was able to come up with a combination of cell formatting and conditional formatting that achieved what I needed, but the end result isn't the spreadsheet, this is a tool to organize their data to be pasted into an InDesign document, so I really need to be able to copy and paste it into that program on a Mac as it shows in the spreadsheet. And so far, nothing I have tried has done this.
