stupid newbie ? - How to escape (+) operator

  • Thread starter Thread starter chrono111
  • Start date Start date
C

chrono111

Ok, I'm not at all an excel expert. I'm importing quite a bit of dat
and some of the values contain a "+" symbol in front of it. Fo
example "+G". How the hell do you prevent excel from trying t
calculate this. I just want it to act like a string. I've searched
while and can't find anything so far. I'm sure you excel veteran'
know right away. That's why I'm here. Any help is much appreciated.

-Jef
 
Try pre-formatting your cells as text prior to importing.

HTH
Jason
Atlanta, GA
 

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

Back
Top