This is driving me crazy!
I'm making a Microsoft Excel 97 index of movies I've got.
Column A = Movie number
Column B = Movie name
Column C = Starring
Column D = Genre
etc. etc.
The trouble is, one of my movies stars an actress named Myu, and when I enter "Myu" into Column C, it gets changed to "My"
The cell (in fact the whole column) is formated as "text", so I've no idea why the cell is not allowing me to enter the text exactly as written.
I've tried changing the cell format to "General", but Excel still changes Myu to My.
Any ideas?
EDIT UPDATE
If I type Myu in a cell, then highlight/copy, press "return" and it'll change from Myu to My in the cell, but if I then delete the "My", and Paste the saved "Myu" into the cell it'll stay as "Myu"... Gawd.....
+ Reply to Thread
Results 1 to 3 of 3
-
-
Same things happens with me.
Ive not used Excel 97 for a while, but now use Excel 2003.
This is the AutoCorrect options thats the culprit.
Click on Tools --> AutoCorrect Options --> click on the Replace button and type in myu, now click on the delete tab. problem solved
Similar Threads
-
problem with copying in Microsoft Excel
By mazinz in forum ComputerReplies: 1Last Post: 30th Mar 2010, 19:45 -
how to find index file for second movie on BluRay?
By dbclark1 in forum EditingReplies: 2Last Post: 10th Feb 2010, 12:37 -
Single huge lossless AVI file index problem
By Gargalash in forum Newbie / General discussionsReplies: 12Last Post: 20th Nov 2009, 18:37 -
How to activate macro's in Excel 2007 with a spreadsheet from Excel 97
By blinky88 in forum ComputerReplies: 3Last Post: 11th Feb 2009, 11:21 -
Can an avi tutorial movie be started from a cell in Excel
By Firewire60 in forum ComputerReplies: 1Last Post: 29th Feb 2008, 05:30