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!
|