Apostrophe Infront of Text & Numbers

  • Thread starter Thread starter amandahardy2005
  • Start date Start date
A

amandahardy2005

I am running excel 2003. When I enter anything (numbers, letters, ect) into
excel; excel automatically puts an 'apostrophe' infont of it:

Example:

The cell should look like this:

123

But it appears like this:

'123

This prohibits me from doing V-Look Up's, ect.

Please HELP!
 
Tools>Options>Transition.

Uncheck the three bottom options.


Gord Dibben MS Excel MVP
 

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