Forum Discussion
david nickerson
May 19, 2018Copper Contributor
Negative key pastes text into cell
Hi
When I try to enter a negative number in an excel cell using the - key, when I add a number it pastes a piece of text into the cell. I recognise the text as some of mine but i do not know how it became attached to the key and number . Im using excel for mac Any ideas on what i've done and how to stop it
Hi david nickerson,
Check 'Auto Correct Options' in your 'Excel Options'.
Search Symbol '+' or '-' which replaces text.
- Logaraj SekarSteel Contributor
Hi david nickerson,
Check 'Auto Correct Options' in your 'Excel Options'.
Search Symbol '+' or '-' which replaces text.
- david nickersonCopper Contributor
Totally nailed it. Many thanks