View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default Problem with inserting diacritics / special signs

Hi, on my PC I have installed 3 languages (2 Slavic plus English).
When I create formulas, I usually switch to English to be able to type
all of these #$^&:;". When I attempt to insert following signs: ^ "
(power sign and/or quotation sign), usually they are not visible
immediately. They appear only after hitting another key (whatever one,
which then I need to delete, or after hitting spacebar). Does anybody
know how can I fix this problem? I know this is rather not "Excel
question", but I really like the forums here and rely on somebody's
smart advice. Thanks in advice.


This may or may not help you -- I don't have the setup to test it -- but it
is possible to enter those characters without using the keyboard with Excel
2003. I saw this in somebody else's previous post to this newsgroup.

The idea is to have buttons in a toolbar that can be clicked with a mouse
instead of typing. That way, perhaps you can avoid switching to English for
those characters.

To get started:
- Right-click on the tool-bar area and click "customize."
- Click on the Commands tab.
- In the left column, select "Insert"
- In the right column scroll down about half way.
The right column should show "=" "+" and other math symbols. These can be
dragged one by one to toolbars. I added a "Math" toolbar to hold them.


If that doesn't work, maybe you could add "Auto-correct" items to avoid
switching keyboards; for example, set up
,4,
To auto-correct to
$