Umlaute with Excel

[K. W. Roggenkamp]

I have a US-keyboard, but I often have to write Excel-
table in German. How can I make a Macro say "Ctr a" for a-
umlaut? Can I do this globally under "Windows"?

Thanks, Klaus Roggenkamp

 

[Bernie Deitrick]

Klaus,

You can't use a macro while you're typing in a cell. Instead, to produce ä
hold down the Alt key and using your numeric keypad, enter 0228.

That is, if two dots is an umlaut - I'm not certain this early in the
morning ;-)

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Klaus,

You can't use a macro while you're typing in a cell. Instead, to
produce ä hold down the Alt key and using your numeric keypad, enter
0228.

That is, if two dots is an umlaut - I'm not certain this early in the
morning ;-)

Bernie
you got it right - even early in the morning
Frank

 

[Bernie Deitrick]

Klaus,

I should have mentioned that you can produce a list of all available
characters by entering

=CHAR(ROW())

into cell A1 and copying down to A2:A255. When you want a character, say ë,
then you'll see that it is in row 235 and that you should use alt-0235 to
produce it.

HTH,
Bernie
MS Excel MVP

 

[Michael Bednarek]

I have a US-keyboard, but I often have to write Excel-
table in German. How can I make a Macro say "Ctr a" for a-
umlaut? Can I do this globally under "Windows"?

Try the Microsoft Visual Keyboard at:
<http://www.microsoft.com/downloads/details.aspx?FamilyID=86A21CBA-E9F6-41DB-86EB-2ADFE407E620>