How do I accent the letter "e" with ` or ' in Excel?

You can use Char() entries.

Hold down <Alt, and use the numbers from the NUM keypad, *not* the numbers
under the function keys:

<Alt0200 = È
<Alt0201 = É
<Alt0232 = è
<Alt0233 = é

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"burric" wrote in message
...
How do I accent the letter "e" with ` or ' in Excel?

Alt + 138 (using the number keypad)

or the formula =CHAR(232), which you can concatenate like

="This is an example: "&CHAR(232)


"burric" wrote:

How do I accent the letter "e" with ` or ' in Excel?

Definitely helped! Thank you RD!

Burric

"Ragdyer" wrote:

You can use Char() entries.

Hold down <Alt, and use the numbers from the NUM keypad, *not* the numbers
under the function keys:

<Alt0200 = È
<Alt0201 = É
<Alt0232 = è
<Alt0233 = é

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"burric" wrote in message
...
How do I accent the letter "e" with ` or ' in Excel?

For me, Alt 232 returns this: Φ
and Alt 138 returns: è

If your machine returns different characters, do you have any ideas what the
difference is?
Thanks!

"Ragdyer" wrote:

You can use Char() entries.

Hold down <Alt, and use the numbers from the NUM keypad, *not* the numbers
under the function keys:

<Alt0200 = È
<Alt0201 = É
<Alt0232 = è
<Alt0233 = é

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"burric" wrote in message
...
How do I accent the letter "e" with ` or ' in Excel?

I get *exactly* what you get, using your numbers.

BUT ... my suggestions include *4* digits.
I didn't add leading 0's because I like to type!<bg

Try it, you might like it.<g
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JMB" wrote in message
...
For me, Alt 232 returns this: Φ
and Alt 138 returns: è

If your machine returns different characters, do you have any ideas what
the
difference is?
Thanks!

"Ragdyer" wrote:

You can use Char() entries.

Hold down <Alt, and use the numbers from the NUM keypad, *not* the
numbers
under the function keys:

<Alt0200 = È
<Alt0201 = É
<Alt0232 = è
<Alt0233 = é

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"burric" wrote in message
...
How do I accent the letter "e" with ` or ' in Excel?

I just figured that's what I get for getting a cheap keyboard. Thanks for
pointing me in the right direction.

"Ragdyer" wrote:

I get *exactly* what you get, using your numbers.

BUT ... my suggestions include *4* digits.
I didn't add leading 0's because I like to type!<bg

Try it, you might like it.<g
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JMB" wrote in message
...
For me, Alt 232 returns this: Φ
and Alt 138 returns: è

If your machine returns different characters, do you have any ideas what
the
difference is?
Thanks!

"Ragdyer" wrote:

You can use Char() entries.

Hold down <Alt, and use the numbers from the NUM keypad, *not* the
numbers
under the function keys:

<Alt0200 = È
<Alt0201 = É
<Alt0232 = è
<Alt0233 = é

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"burric" wrote in message
...
How do I accent the letter "e" with ` or ' in Excel?

Another method I have used is to paste it in from Word, which is slower than
the Alt+ options but OK if you forget which characters to use and you are use
to doing it in Word.

"burric" wrote:

How do I accent the letter "e" with ` or ' in Excel?

People, you missed the obvious!
Click Insert, Symbol and choose the character.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563528

Can't find that on my machine (and don't remember ever seeing it). I've got
XL2000, which version are you using?

He could also use paste it in from the character map, which I see also tells
you what keystroke to use (which is a feature I never really noticed before
now - 0232 as Ragdyer posted).


"raypayette" wrote:


People, you missed the obvious!
Click Insert, Symbol and choose the character.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563528

JMB

InsertSymbol was introduced with 2002 version.


Gord Dibben MS Excel MVP

On Fri, 21 Jul 2006 08:49:01 -0700, JMB wrote:

Can't find that on my machine (and don't remember ever seeing it). I've got
XL2000, which version are you using?

He could also use paste it in from the character map, which I see also tells
you what keystroke to use (which is a feature I never really noticed before
now - 0232 as Ragdyer posted).


"raypayette" wrote:


People, you missed the obvious!
Click Insert, Symbol and choose the character.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563528

Thanks for clearing that up.

"Gord Dibben" wrote:

JMB

InsertSymbol was introduced with 2002 version.


Gord Dibben MS Excel MVP

On Fri, 21 Jul 2006 08:49:01 -0700, JMB wrote:

Can't find that on my machine (and don't remember ever seeing it). I've got
XL2000, which version are you using?

He could also use paste it in from the character map, which I see also tells
you what keystroke to use (which is a feature I never really noticed before
now - 0232 as Ragdyer posted).


"raypayette" wrote:


People, you missed the obvious!
Click Insert, Symbol and choose the character.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563528

All of this is very true, but I do lean with RagDyer on this one. If it's
only a once-a-year usage, insert symbol would work. However, if you use it
more frequently, you can click out the Alt#### sequences a lot faster. That
was the useful part of co-lab training as a Spanish major... Alt-0224, 0233,
0237, 0241, 0243, 0250, etc.
-MikeDH

"JMB" wrote:

Thanks for clearing that up.

"Gord Dibben" wrote:

JMB

InsertSymbol was introduced with 2002 version.


Gord Dibben MS Excel MVP

On Fri, 21 Jul 2006 08:49:01 -0700, JMB wrote:

Can't find that on my machine (and don't remember ever seeing it). I've got
XL2000, which version are you using?

He could also use paste it in from the character map, which I see also tells
you what keystroke to use (which is a feature I never really noticed before
now - 0232 as Ragdyer posted).


"raypayette" wrote:


People, you missed the obvious!
Click Insert, Symbol and choose the character.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563528

Hi all!

Somehow, holding Alt and typing the numbers from my numpad doesn't work for
me. I just get numbers. Is there a difference when using a mac keyboard? I
noticed that I don't have a num key and my alt key is mainly called option
(with alt only in tiny superscript).

I'm also confused because I've got excel 2004, which from your description
should have the symbol menu included, but it doesn't.

Could you please help me how to quickly insert lots of different symbols
(pasting from word is just such a pain and also makes other parts of the same
cell show up in Greek as well).

Cheers,

If you have a Mac, you'll likely have more success posting to the Mac group
rather than the PC group. Try: microsoft.public.excel.macintosh.

Regards,
Fred.

"Bine_NZ" wrote in message
...
Hi all!

Somehow, holding Alt and typing the numbers from my numpad doesn't work
for
me. I just get numbers. Is there a difference when using a mac keyboard? I
noticed that I don't have a num key and my alt key is mainly called option
(with alt only in tiny superscript).

I'm also confused because I've got excel 2004, which from your description
should have the symbol menu included, but it doesn't.

Could you please help me how to quickly insert lots of different symbols
(pasting from word is just such a pain and also makes other parts of the
same
cell show up in Greek as well).

Cheers,