I type 30% but 30... shows in cell - why?

  • Thread starter Thread starter Bennyboy
  • Start date Start date
B

Bennyboy

I have just cleaned my keyboard and now when I type in a % then click out of
the cell the % turns into three little dots ...
What have I done?????
 
It sounds like autocorrect is "helping" you.

In xl2003 menus:
Tools|autocorrect options|autocorrect tab

Look for that % and delete its entry.

ps. Those three little dots are called an ellipsis. And you may find that the
"..." string is autocorrected to a single character (the ellipsis character) in
that same autocorrect dialog.
 
You must log in or register to reply here.

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

What is the Difference Between <30 and .<30 5
in excel I wish to show 7:30 (7 hours 30 minutes) as 7.5 hours 1
cell lenght MUST be always 30 8
How to filter rows data based on background color of individual cells 1
Cell shows the last typed text, no matter where it is typed 0
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
How do I Lock cells to a sheet background 1
Excel Typed text appears in wrong cell 0

Back
Top