Hello,
I am using Excel 365 and have an issue that has appeared sometime within the last 30 days with regards to how Excel opens and converts CSV (comma separated values) files.
I normally open several CSV format files every month. When I open the files, Excel parses out the columns automatically. One of the columns has items that begin with the @ symbol. Previously, this was left as a text field when opened in Excel. Now, when I open these files, there is = sign in front of the @ symbol so Excel thinks this is a formula and then returns the error #name?. Data example below:
SERIAL#, MODEL#, TYPE,PART, PART DESCRIPTION
"SERIAL#1","'0123456","AAA","@thing1","THING ONE"
"SERIAL#2","'0987654","BBB","@THING2","THING TWO"
The PART column with @thing1 appears as =@THING1 which returns the error.
It seems there may have been a logic change of some sort with Excel 365 on how it interprets the @ symbol sometime within the last 30 days.
Any thoughts on how or why this is happening and any way to prevent it?
Thank you
I am using Excel 365 and have an issue that has appeared sometime within the last 30 days with regards to how Excel opens and converts CSV (comma separated values) files.
I normally open several CSV format files every month. When I open the files, Excel parses out the columns automatically. One of the columns has items that begin with the @ symbol. Previously, this was left as a text field when opened in Excel. Now, when I open these files, there is = sign in front of the @ symbol so Excel thinks this is a formula and then returns the error #name?. Data example below:
SERIAL#, MODEL#, TYPE,PART, PART DESCRIPTION
"SERIAL#1","'0123456","AAA","@thing1","THING ONE"
"SERIAL#2","'0987654","BBB","@THING2","THING TWO"
The PART column with @thing1 appears as =@THING1 which returns the error.
It seems there may have been a logic change of some sort with Excel 365 on how it interprets the @ symbol sometime within the last 30 days.
Any thoughts on how or why this is happening and any way to prevent it?
Thank you