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 ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.

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.