Forum Discussion
format of data changes
hi, am trying to copy data from a DB2 table into excel but in some cases the value changes from txt to a date. Example: normally this is the value you want to see in excel= -1.10 as it is stored ...
Hi Maarten,
To my knowledge that's no a lot what you can do with autoformat in Excel. If suitable you may try to format cell as text before you copy the data. Or use Power Query for proper transfer data from DB2 to Excel. Bit more about that issue is here https://excel.tips.net/T003019_Defeating_Automatic_Date_Parsing.html