How to keep CV formatting when exporting to Excel?

[skyzak22]

I need help with keeping some CV formatting when exporting to Excel. The current CV I've built works just fine, but when the client exports to Excel, some of the percent values are truncated to the whole number and the '%' is removed.

EX: OneStream CV shows a cell value as "35.6%", but Excel shows "35"

I've tried to mess around with the Excel formatting in the designer tab for CV's, but I cannot get the setting to carry over during export. Any advice would be much appreciated! 

[plaabs25 · Accepted solution]

You mention that some of the percent values are truncated. I would double-check the ExcelNumberFormat you have on the default settings of your CV as well as your rows and columns. If you have formatting on both default as well as columns, the column format will override the default settings. If that doesn't help, can you provide some screenshots of your ExcelNumberFormat for both default and the rows/columns not showing the correct format to help us see some of your settings?