Strange characters in Excel

S

Suresh

The PC group installed MS Office 2007 on my PC. Since then
the character < is translated to &lt;
This also happens on other special characters. Is there a setting in
Excel 2007 that I can turn on to prevent this translation(?). Or how
can I avoid this problem.

Thanks,


Suresh Bhat
 
M

Matt Richardson

The PC group installed MS Office 2007 on my PC.  Since then
the character < is translated to &lt;
This also happens on other special characters.  Is there a setting in
Excel 2007 that I can turn on to prevent this translation(?).  Or how
can I avoid this problem.

Thanks,

Suresh Bhat

The symbol &lt; is HTML.. Does this happen when you press the '<' key
or when you copy and paste data from other sources? It may be that
you have to do a find and replace for '&lt;', or maybe if you're
pasting from another source do a paste special... and paste values?
Might work.

HTH

Matt
http://2toria.com
http://teachr.blogspot.com
 
S

Suresh

The symbol &lt; is HTML..  Does this happen when you press the '<' key
or when you copy and paste data from other sources?  It may be that
you have to do a find and replace for '&lt;', or maybe if you're
pasting from another source do a paste special... and paste values?
Might work.

HTH

Matthttp://2toria.comhttp://teachr.blogspot.com

Thanks for the reply.

Actually, I am creating a TEXT file in Oracle PL/SQL program with
special characters <, > etc. and save it as a CSV file. Then I open
it in Excel
and this is when this HTML translation happens.

Any solution suggestions are appreciated.

Thanks,

Suresh
 

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

Top