We are creating reports using SAS Add-in in Excel. For some reason, the formating that we are applying to the data in our SAS code are not kept in Excel.

For exemple, if we want a variable to keep 2 decimals even if the last one is a zero, the zero is not displayed in Excel. Or if we want "N/A" to be displayed in each cell where we have a -9, it doesn't take it.

Any idea why? How can we resolve the problem?

Thanks,
Mylène