VideoHelp Forum




+ Reply to Thread
Results 1 to 3 of 3
  1. Member
    Join Date
    Jun 2003
    Location
    United Kingdom
    Search Comp PM
    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.....
    Quote Quote  
  2. Member waheed's Avatar
    Join Date
    Jul 2003
    Location
    Manchester, UK
    Search Comp PM
    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
    Quote Quote  
  3. Member
    Join Date
    Jun 2003
    Location
    United Kingdom
    Search Comp PM
    Thanks - You're a lifesaver
    Quote Quote  



Similar Threads

Visit our sponsor! Try DVDFab and backup Blu-rays!