Shift and number

  • Thread starter Thread starter cbayardo
  • Start date Start date
C

cbayardo

Hi,
This started happening while I was working in Excel 2000,
I tried to use the equal sign "=" in a formula and instead
of getting the equal sign I was getting Pts instead. And
the ")" was giving me something different. This only
happens in Excel.
Anybody has had this problem?

Thanks
 
Hello

No idea why this should happen in Excel. But you can take
advantage of Excel's CODE and CHAR functions.

If A1 contains "=" then Code(A1) returns 61.
To enter an equals sign from the keyboard, Hols down the
ALT key and using the number pad type "61" then release
this enters an equal sign then complete your formula.

To find the code for each character type a set of numbers
1 .. to 256 and use the function CHAR(cell ref) to find
the character.

Of course you can just click the equal sign on the formula
bar and this will enter "=" for you

Regards
Peter
To reply remove NotHere
 
Any chance that = is being autocorrected with pts.

Tools|autocorrect options|Autocorrect tab

(and look for the close parenthesis, too.)

(I think that this autocorrect list is used in all of MSOffice--including word.
Maybe you haven't typed = or ) in that application for awhile.)
 
Back
Top