Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Suddenly a caret sign appears every time I type an equal = sign
I have been working for hours in a spreadsheet of recording and projecting financial performance of a company and suddenly the caret symbol appears in the new cell every time I type the equal = sign, and I am then unable to reference another cell or input a function. I can't figure out how this must have been turned on or how to turn it off. I can copy and paste functions starting with equal sign and then back into the formula I want, but not start fresh. I also just discovered that the caret mistakenly replaces the = sign everywhere I type it--even in a comment box. I have used Excel for 30 yrs and never have seen this before. How do I fix this?
Last edited by Dreamspinnr : October 30th 14 at 02:39 AM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suddenly a caret sign appears every time I type an equal = sign
On Wednesday, October 29, 2014 7:49:05 PM UTC-7, Dreamspinnr wrote:
I have been working for hours in a spreadsheet of recording and projecting financial performance of a company and suddenly the caret symbol appears in the new cell every time I type the equal = sign, and I am then unable to reference another cell or input a function. I can't figure out how this must have been turned on or how to turn it off. I can copy and paste functions starting with equal sign and then back into the formula I want, but not start fresh. I also just discovered that the caret mistakenly replaces the = sign everywhere I type it--even in a comment box. I have used Excel for 30 yrs and never have seen this before. How do I fix this? This is strange. Two possibilities occur to me, but these are admittedly unlikely. 1. The keyboard is broken, or its software driver. This can be checked by typing with another program. 2. A bogus auto-correct entry got introduced somehow. With Excel 2010, these appear in File Options Proofing AutoCorrect Options |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As Box Appears When I Hit the = sign! | New Users to Excel | |||
Numerical Data Appears with - Sign | Excel Discussion (Misc queries) | |||
Plus sign no longer appears when cell is selected | Excel Discussion (Misc queries) | |||
Why a plus sign after the equal sign? | Excel Discussion (Misc queries) | |||
EQUAL SIGN | Excel Discussion (Misc queries) |