2 = 6

D

DMichalek

I have a problem unique to Excel 9.0.

When I type my "2" key, in any cell, I get a "6". $2.11 will yeild the value $6.11 in the cell, 9.2 yeilds the value 9.6 and so on. However when I type "27", for example, I get "27" in my celll, "02", then Excel gives me a "2", 9.23=9.23.

Is this a bug or is it possible that I've toggled a particular setting on?
 
K

Ken Wright

Tools / Autocorrect - Search for the 6 and delete it. Then look round and see
who is laughing (The guilty party) and plan your revenge. :)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



DMichalek said:
I have a problem unique to Excel 9.0.

When I type my "2" key, in any cell, I get a "6". $2.11 will yeild the value
Click to expand...
$6.11 in the cell, 9.2 yeilds the value 9.6 and so on. However when I type
"27", for example, I get "27" in my celll, "02", then Excel gives me a "2",
9.23=9.23.
 
J

Jim Rech

Open your AutoCorrect list (Tools, AutoCorrect) and scroll down the list at
the bottom and see if "2" appears in the left column. If it's there delete
it.
 
P

Peo Sjoblom

Someone has edited your autocorrect, tools>autocorrect
you can delete that entry from there

--

Regards,

Peo Sjoblom


DMichalek said:
I have a problem unique to Excel 9.0.

When I type my "2" key, in any cell, I get a "6". $2.11 will yeild the
Click to expand...
value $6.11 in the cell, 9.2 yeilds the value 9.6 and so on. However when I
type "27", for example, I get "27" in my celll, "02", then Excel gives me a
"2", 9.23=9.23.
 
Top