| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I type 30% but 30... shows in cell - why?
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????? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I type 30% but 30... shows in cell - why?
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. Bennyboy wrote: 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????? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
| when I type 100 in a cell 181 shows | Excel Discussion (Misc queries) | |||
| cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
| using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) | |||
Linear Mode
