MrExcel Publishing
Your One Stop for Excel Tips & Solutions

1' (number one) turning into 'y' (letter y) - Whats going on

Posted by Simon Smith on October 16, 2001 2:14 AM

if i type 123, that fine, if i type 111 thats fine, so is 11,but when i press return on 1 it turns into a y !!

this happens in a new spreadsheet, or any existing spreadsheet, if i take an existing spreadsheet to another PC on floppy its fine, so its definatley this pc. ive reinstalled excel, but to no avail, started happing a couple of weeks ago.

My control panel settings are correct at UK settings.

Dont know what else to try.

Any help would be greatly appreciated.


Simon Smith

Posted by Paul on October 16, 2001 2:58 AM

You might want to look under tools auto correct, see if there is a 1 listed under replace and a y under with if so delete them.