topic Re: Export to Excel : keeping the number format in Discussions

Export to Excel : keeping the number format

GroupSquareWolf — Fri, 09 Jun 2023 16:01:35 GMT

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?

Re: Export to Excel : keeping the number format

monique_lander — Tue, 08 Nov 2022 12:54:58 GMT

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).