C
ciruliz
Hello,
I am having difficulties while opening CSV files:
If there is value i.e "6.1" which is decimal, Excel interprets it as date =
01. June (According to regional date settings)
If there is value "16.04.07" which is actually date 2007-04-16, Excel again
converts it according to regional settings, and finally there is 2016.04.07
Is there any settings or macros available, so I can open CSV file, and treat
each column just as TEXT ? without any auto-guessings about cell type.
Import wizard is not good solution this time. Also playing with regional
settings is not recommended.
Thanks a lot !
Andis
I am having difficulties while opening CSV files:
If there is value i.e "6.1" which is decimal, Excel interprets it as date =
01. June (According to regional date settings)
If there is value "16.04.07" which is actually date 2007-04-16, Excel again
converts it according to regional settings, and finally there is 2016.04.07
Is there any settings or macros available, so I can open CSV file, and treat
each column just as TEXT ? without any auto-guessings about cell type.
Import wizard is not good solution this time. Also playing with regional
settings is not recommended.
Thanks a lot !
Andis