Importing text files with mathematical characters

[The Beckster]

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 Beckster@discussions.microsoft.com> wrote in message
news:07D6533B-0C29-4287-9ECE-A337DE39DB8D@microsoft.com...
> 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