When I type "13" the spreadsheet shows "14." Possibilities?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot find the Option that may be causing this. If I send the spreadsheet
to another system there is no problem typing the number "13" (does not
automatically change to "14"), and in fact when the spreadsheet is returned
to my sytem, the "13" still exists. But when I data enter a "13," it will
automatically change to a "14." I have checked for a formatting issue, and
even selected cells and then used Edit, Clear, All to remove all formatting,
but still get the 13/14 input error.
 
Check Tools >AutoCorrect and see if there is an entry that is changing 13 to
14 then if there is look around the office and see who is smiling.

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Hi there,
This might be a 'longshot' but I just reproduced your suspect behavior by
entering a '13' and having Excel return a '14'....Go to Tools / Options /
Spelling, click on the "Autocorrect Options" button.... see if someone has
added '13' in the "Replace" column and a '14' in the "With" column.
You may have to scroll down the lists a bit to see if its at the bottom of
the list.

Hope this helps,
Joe
 
You and Sandy are brilliant! That's the one place I have failed to check.
I'm going to scope it out right away.
 
You and Joe are brilliant! That's the one place I have failed to check. I'm
going to scope it out right away.
 
That did the trick! Thank you SO MUCH.

Sandy Mann said:
Check Tools >AutoCorrect and see if there is an entry that is changing 13 to
14 then if there is look around the office and see who is smiling.

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
Click to expand...
 
That was the ticket. Thanks.

Joe said:
Hi there,
This might be a 'longshot' but I just reproduced your suspect behavior by
entering a '13' and having Excel return a '14'....Go to Tools / Options /
Spelling, click on the "Autocorrect Options" button.... see if someone has
added '13' in the "Replace" column and a '14' in the "With" column.
You may have to scroll down the lists a bit to see if its at the bottom of
the list.

Hope this helps,
Joe
Click to expand...
 
I like Sandy's reply better ... ;-) Find the culprit and they should buy
you '13' lunches.
 

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

Similar Threads

Is this possible with excel? 9
tiny discrepancies in fixed-point numbers 3
14 Day Average REVISITED 3
cannot change date format 4
Entering HH:MM 9
When I enter 14 the cell shows 20 3
Formating time 2
Lookup text in array & return cell reference 5

Back
Top