It seems that you need to use a VBA script to format all values as string, or Text as I believe it is labelled in Excel. I don't want Excel to format, change or convert any data, I want to see the raw data. I want to see the exact characters that are in the data file, in my case CSV. I'm having issues with dates and numbers in particular where an integer number may be converted to scientific notation (non destructive), although not always, and dates are converted to numbers (destructive).
0 kommentar(er)
