I have a spreadsheet which is used to calculate a large table of data, which ultimately needs to be copied into another application. The numbers need to be formatted a specific way, some are formatted to 2 decimals, some to 1 decimal. In all cases, if the number >= 10, then only show the decimal if it is not zero. I have the cells formatted to their proper decimal places, and an overriding conditional formatting to remove the decimal from any whole number with 2 or more digits.



When I copy the data from Excel to paste into the other application, the values include the decimals which were removed by the conditional formatting. (e.g. shows as '12' in Excel, but when pasted it shows as '12.0')

I am working on a Mac, which doesn't have the number formatting option in the conditional formatting tab, but the formatting works properly. I set up the formatting on a PC which does have this option. I believe some of the values copied properly where others don't, I'm assuming the values which copy properly formatted were existing when the formatting was set on the PC, and any values which were changed on the Mac are not formatted when copied.

Is there any way to copy the values, including the conditional formatting, properly on the mac?