When exporting datatables to Excel workbooks, the format of the numbers get lost but the color information is retained.
In this table, column 2 is set with 2 fixed decimal points, and column 3 is set with Percent format
numbers in Excel are converted back to the true values.
Is there a way to maintain the formats of numbers in the exporting process?
Accepted Solutions
You can create a separate formula column using the round() formula to round up to the number of decimals you like. For the percentages, instead of adjusting the column format use a x 100 formula column (within Round() if you want to manage the number of decimals for this column). That way your percentage values copy correctly as well. You can do your color cells on these columns to export to Excel.
See the screen paste (formulas are in the column headers).
You can create a separate formula column using the round() formula to round up to the number of decimals you like. For the percentages, instead of adjusting the column format use a x 100 formula column (within Round() if you want to manage the number of decimals for this column). That way your percentage values copy correctly as well. You can do your color cells on these columns to export to Excel.
See the screen paste (formulas are in the column headers).