Excel changing cell format in the data sheet linked to SAP application

[simply_seema]

Hello!

I have a sheet which is bringing data from an internal SAP application via a plugin. There are columns which contains date and percentages. Every time I refresh the data the format of column changes to text and I have to use text to column to change the format. This is frustrating as I have calculated columns based on these other columns.

I have tried formatting as table but that does not work.

your help is appreciated.