cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
GroupSquareWolf
Level III

Export to Excel : keeping the number format

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

GroupSquareWolf_0-1667385590010.png

numbers in Excel are converted back to the true values. 

GroupSquareWolf_1-1667385617863.png

Is there a way to maintain the formats of numbers in the exporting process? 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Export to Excel : keeping the number format

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). 
Screenshot 2022-11-08 064828.pngScreenshot 2022-11-08 064932E.png

 

View solution in original post

1 REPLY 1

Re: Export to Excel : keeping the number format

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). 
Screenshot 2022-11-08 064828.pngScreenshot 2022-11-08 064932E.png