simply_seema
New Member
- Joined
- Sep 15, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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.
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.