ExcelBanter - Importing text files with mathematical characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Importing text files with mathematical characters (https://www.excelbanter.com/excel-discussion-misc-queries/15654-importing-text-files-mathematical-characters.html)

The Beckster

Importing text files with mathematical characters

I am importing text files to Excel and they contain mathematical operators as
part of the data. (For example "++" to denote a quantity of something.) Excel
will not allow these characters as it thinks they are mathematical. Is there
any way of stopping this happening?
Thanks in advance

David Biddulph

"The Beckster" <The wrote in message
...
I am importing text files to Excel and they contain mathematical operators
as
part of the data. (For example "++" to denote a quantity of something.)
Excel
will not allow these characters as it thinks they are mathematical. Is
there
any way of stopping this happening?
Thanks in advance

Format the columns as text when importing.
--
David Biddulph

All times are GMT +1. The time now is 07:03 PM.