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
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
 
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top