"Mike Copeland" wrote:
In the CSV data, I have many values such as "FBM11", "PAT12",
"ABCO07", etc. These are displaying correctly (they're all
text data), but the value "MAY05" displays as "5-May". 8<{{
I know that I could manually change all these values by
prepending a "`" character, but this isn't feasible
[....]
My question is: is there something I can insert into the
CSV text for this value that will cause Excel to treat this
value as a/n text, rather than a "date"?

Not an individual basis ("this value"), but on a column basis.

Instead of opening the CSV file in Excel, use Import External Data to bring
the CSV data into the worksheet. The import wizard allows you to assign a
(limited) type to each column. In particular, you can assign type Text to a
column.

This is an common complaint about Excel interpretation of CSV files: it
always tries to interpret data as numeric representations, just as if you
had entered it manually, even if the data are quoted.

There are no standards for the interpretation (reading) of CSV files. Even
RFC 4180 covers only how to __write__ to CSV files. Moreover, RFC 4180
post-dates the Excel implementation by decades(!).