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.

Thanks

Simon Smith
simonsmith@williamjacks.plc.uk


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.