Forum Discussion
EXCEL Alt shortcut keys problem
Hey, did you ever find a solution to this? It is driving me crazy. I copy/pasted a bunch of data from a USGS website, and was having issues getting the data to be recognized as numbers. Alas, a 10 year old post: https://answers.microsoft.com/en-us/msoffice/forum/all/excel-not-recognizing-numbers-in-cells/d4ee1aa5-533d-44ce-bba8-b315d8191297
gave me the answer. Pasting ALT+1620 into find/replace removes an odd space size and allows excel to recognize this text as a number. Worked on my first chunk of data yesterday. Came back today, to apply the same fix to the rest of the data, and instead of a space entering the "find" dialogue box when I type in ALT+1620, I get the letter "T". Tried typing it in as ALT16+ALT20, different combos, etc, and got a bunch of wingdings, etc.
I think we have the same problem. ALT+1620 worked yesterday, now "T" and various symbols are replacing ALT+ functions in the find/replace box. Please tell me you found something!
- mmserp_May 18, 2022Copper ContributorNo. The suggested fixes either already tried before posting, didn't work or were too drastic.