Umlaute with Excel

  • Thread starter K. W. Roggenkamp
  • Start date
K

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
 
B

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
 
F

Frank Kabel

Bernie said:
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 ;-)
Click to expand...

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

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
 
Top