Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

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


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

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.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.