Importing text files with mathematical characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
The Beckster said:
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
Click to expand...

Format the columns as text when importing.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Problem Is This.......... 7
Imported Data - misinturpretted 3
how to replace an unrecognised character 2
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Importing Text Files Into Access 1
Puzzling quotes around text 2
Rota system 2
Best Tool to Repair Corrupted PDF Files 0

Back
Top