Exporting from ERP system to excel is exported as 'text' and 'number' is needed.

[kettler]

Hi All,

When a user exports from the erp system to excel the column containing data quantity data is exported as 'text' and she needs it to be 'number'.

Although I can manually select the column and change it to 'number' is there any way to have the export done automatically?

The issue however is on a user's PC whereas when I export its fine.

 

[pbornemeier]

If the imported text values are always in the same column, you could add code that could multiply the values by 1 which would force it to change to numbers.

 

[kettler]

The problem is that the export is always to a new worksheet.

 

[pbornemeier]

If the export format is consistent (columnwise), when that workbook is opened, the conversion code could be set to check if the conversion has already been done, and if not, convert and save the code.

 

[Derek Brown]

If that user opens a new workbook/worksheet, what is the formatting applied to that column?
I am wondering if that user has modified the Book or Sheet templates.