input "20" get "twenty"

R

Rick

I have Excel 2000 and when I input "20" into a cell and
press Enter I see "twenty" on the screen.

Any idea?
 
K

Ken Wright

You either have an event macro running, or in Autocorrect, someone has instructed Excel to
replace 20 with twenty.

Look in Tools / Autocrrect Options, and search for 20. If you find it then just delete
it.
 
R

rick

i found both 20 and 80 replaced with twenty and eighty.

i have NO idea how that got in there.

it was driving me crazy.

thank you very much !
-----Original Message-----
You either have an event macro running, or in
Click to expand...
Autocorrect, someone has instructed Excel to
replace 20 with twenty.

Look in Tools / Autocrrect Options, and search for 20.
Click to expand...
If you find it then just delete
 
K

Ken Wright

If it hasn't happened before, take a look round the office and see who might be having a
laugh at your expense :)
 
Top