"Latin small letter x with macron" in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Opinicus - 12 Oct 2007 08:51 GMT

{Excel 2002. All updates in place.)

How do I enter a "Latin small letter x with macron"? (A small x with a bar
over it.) From Insert > Symbol it seems I can enter letters with macrons for
just about every character *except* x.

Signature

Bob
http://www.kanyak.com

Reply to this Message

Zone - 12 Oct 2007 12:26 GMT

Can't find it either. Weird! It seems it's being intentionally skipped.
Maybe there is a special font available that has it. Otherwise, I can't
think of a solution other than drawing in the bar with the drawing toolbar.

> {Excel 2002. All updates in place.)
>
> How do I enter a "Latin small letter x with macron"? (A small x with a bar
> over it.) From Insert > Symbol it seems I can enter letters with macrons
> for just about every character *except* x.

Reply to this Message

Michael Bednarek - 12 Oct 2007 13:31 GMT

>{Excel 2002. All updates in place.)
>
>How do I enter a "Latin small letter x with macron"? (A small x with a bar
>over it.) From Insert > Symbol it seems I can enter letters with macrons for
>just about every character *except* x.

As the macron normally denotes a long vowel, there is no such glyph in
Unicode. However, there are combining diacritical marks in Unicode, and
the macron is x0304.

Steps:
Run Charmap; select font Lucida Sans Unicode; Go to Unicode: 0304;
press Select, Copy.

Run Notepad; type xCtrl+v. (That is the letter x followed by Ctrl+v)
This will create an x+macron.
Ctrl+a Ctrl+c will Select All and Copy.

Run Excel; in a cell, Ctrl+1 and select Font Lucida Sans Unicode;
Ctrl+v - voilà.

There might be simpler methods, e.g. with Unicode Input from
<http://www.fileformat.info/tool/unicodeinput/index.htm> or other such
programs, or finding a font which has such a character built-in,
possibly in a Reference or Mathematica font (although I haven't found
it).

Signature

Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

Reply to this Message

Dave Peterson - 12 Oct 2007 13:36 GMT

Maybe this tip from Debra Dalgleish will help:
http://contextures.com/xlfaqFun.html#bar

> {Excel 2002. All updates in place.)
>
[quoted text clipped - 5 lines]
> Bob
> http://www.kanyak.com

Signature

Dave Peterson

Reply to this Message

Ron Rosenfeld - 12 Oct 2007 13:42 GMT

>{Excel 2002. All updates in place.)
>
>How do I enter a "Latin small letter x with macron"? (A small x with a bar
>over it.) From Insert > Symbol it seems I can enter letters with macrons for
>just about every character *except* x.

You can enter it either as a custom font character, or as an object.

There is the Private Character Editor supplied with Windows.
You can create custom characters with it and make them part
of one or more fonts.
In "Run" enter: eudcedit.exe
You will have to read the help file.

OR

You can use Microsoft's Equation Editor;

From the main menu bar:
    Insert/Object
        Create New
        Microsoft Equation 3.0

Then type <x> <ctrl-shift-hyphen>

You may want to format the object as <no line> when you get back to the main
worksheet.
--ron

Reply to this Message

Opinicus - 13 Oct 2007 13:49 GMT

> You can use Microsoft's Equation Editor;
>
[quoted text clipped - 6 lines]
> main
> worksheet.

That's exactly what I wanted. Thanks!

Signature

Bob
http://www.kanyak.com

Reply to this Message

Ron Rosenfeld - 13 Oct 2007 14:00 GMT

>> You can use Microsoft's Equation Editor;
>>
[quoted text clipped - 8 lines]
>
>That's exactly what I wanted. Thanks!

You're welcome. Glad to help.
--ron

Reply to this Message