J
Jared
Hello people,
When I open a .csv (comma seperated values) file with EXCEL, I would
like EXCEL to open all data as text data. This is a requirement for
me because some data I wish to display to the user begins with a - or
= so EXCEL automatically treats this data as an equation. This
wouldn't be a problem, except EXCEL allows a much lower number of
characters to be entered into an equation than into a text cell.
Therefore, the text in some of the cells that are being treated as
equations is truncated when I open the .csv file.
Does anybody know an EXCEL option I can change so that it treats all
data as text data when I first open an EXCEL file?
Thanks a lot!
Jared Hagel
When I open a .csv (comma seperated values) file with EXCEL, I would
like EXCEL to open all data as text data. This is a requirement for
me because some data I wish to display to the user begins with a - or
= so EXCEL automatically treats this data as an equation. This
wouldn't be a problem, except EXCEL allows a much lower number of
characters to be entered into an equation than into a text cell.
Therefore, the text in some of the cells that are being treated as
equations is truncated when I open the .csv file.
Does anybody know an EXCEL option I can change so that it treats all
data as text data when I first open an EXCEL file?
Thanks a lot!
Jared Hagel