We want to transfer some data (stock transfer draft) to excel format. However when doing this, the numeric fields are incorrectly transferred to excel. For example, if we have in the system field "Quantity" the value:
1,000.0000 (one thousand)
then that value is transfered to excel:
Do you know how could be this avoided?
This is a big complaint I have with the flat file choices for importing data to DTW. When using Excel, if you aren't vigilant about your formats, text fields that look numeric and have leading zeros are chopped. Long strings, like international phone numbers, show up in E notation.
Also, delimiter choices should be expanded. A lot of data I need to import has embedded commas. Some 'remarks' type fields even have embedded semicolons. I have been working with ODBC connections rather than flat files for these reasons. That's my workaround, but hardly any of my clients will be able to use it when they import their own data.