How do I insert a ~ over a letter?

[Guest]

I have used ALT164 previously in WORD to get a ~ over the letter n, but am
unable to find a shortcut for EXCEL. Please advise.

 

[Juan Pablo González]

209 is Ñ
241 is ñ

 

[David J. Braden]

Juan,
I can't replicate what you suggest on my version of Excel (win 11). Do you
mean hold, say, the alt key down while punching in the codes, or what? (man,
it is so much easier to accomplish on the mac <vbg>)

Muchas gracias,
david braden

(quiero aprendar espanol, pero hablo solamente alemagn y ingles; pardonome)

 

[Gord Dibben]

David

Make sure you have NumLock turned on.

Hold ALT and hit 0241 on the NumPad, not the Shifted keys above qwerty.

Gord Dibben Excel MVP

 

[David McRitchie]

Hi Juan,

You can always type in ALT+nnnn with the n being a number
from 0032 to 0255 typed on the numeric keyboard (NumLock on),

on a laptop Fn+Alt+nnnn with NumLock off

on non US keyboard that might be
RtALT+nnnn US keyboards do not distinguish between the
ALT key on the left or the the right.
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm

But here is the page you probably want to look at for shortcut keys
http://www.starr.net/is/type/kbh.html#easteuro

though I can't find what I am missing to get the following to work
I changed my keyboard to
English(United States) and on the right with properties to
International English from US
it appears to want a reboot, which I did not try, so I put it back
to English(United States) US

But you are supposed to be able to get, and I presume lose
the ability to use Ctrl+: (colon) to get the date in Excel.

à, è, ì, ò, ù - À, È, Ì, Ò, Ù
CTRL+` (ACCENT GRAVE),
á, é, í, ó, ú, ý - Á, É, Í, Ó, Ú, Ý

CTRL+' (APOSTROPHE),

â, ê, î, ô, û Â, Ê, Î, Ô, Û
CTRL+^ (CARET),

ã, ñ, õ Ã, Ñ, Õ
CTRL+~ (TILDE),

ä, ë, ï, ö, ü, ÿ Ä, Ë, Ï, Ö, Ü, Ÿ
CTRL+: (COLON), the letter



--

 

[Juan Pablo González]

Yes David,

That's what I mean. If that doesn't work, then =CHAR(209) or =CHAR(241)
should do it at least ! <g>

And I hope you can learn spanish... I've been (trying to) learn french, and
the hardest part is not having where/how to practice it... and also, German
seems SO much complicated to me than Spanish <vbg>

 

[Guest]

Thanks to all of you - it works!

Yes David,

That's what I mean. If that doesn't work, then =CHAR(209) or =CHAR(241)
should do it at least ! <g>

And I hope you can learn spanish... I've been (trying to) learn french, and
the hardest part is not having where/how to practice it... and also, German
seems SO much complicated to me than Spanish <vbg>