View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Apostrophe Infront of Text & Numbers

ToolsOptionsTransition.

Uncheck the three bottom options.


Gord Dibben MS Excel MVP

On Thu, 22 May 2008 10:04:04 -0700, amandahardy2005
wrote:

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!