Number stored as text warnings while exporting the data to Excel using Export to Excel pugin

Hi Team,

I am using Export to Excel plugin to write the data to Excel which is coming as individual process variables

There are some of the numeric values which are coming and should be written in excel, I tried to give the formatting in the base template for the corresponding columns as number

But when it tried to write the data to excel it generates certain dirty warnings for those numeric column as "Number is stored as text"

Then I revert the type of the variables and  tried keeping everything as text from the process variables as well as in Excel marked those columns as General

but even then it generates those warning

Now main issue is that We need to do the export to excel followed by an import to CDT, after making the changes to the columns of the excel which generates after Export to Excel

but during parsing it fails as it says as Invalid excel sheet

I would appreciate any help in this regard.

Below is the excel columns which generate warnings

Thanks-

Ruchi