×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Greek letters in Excel 2000

Greek letters in Excel 2000

Greek letters in Excel 2000

(OP)
I need to put Greek letters in an Excel 2000 spreadsheet - phi, gamma, rho, delta, etc.  I've done it in Quattro Pro 10 by simply changing the font for the character in question, but it doesn't seem to work in Excel.  Any suggestions?  Thanks!

RE: Greek letters in Excel 2000

yep!

type the a-b-c letters in UPPER and lower case in two adjacent columns.  change the format to "symbol" and observe the results.

this can also be applied to "in-cell" editing.

fyi, for other special characters, try fonts wingdings and webdings.
-pmover

RE: Greek letters in Excel 2000

Focht3

pmover is exactly right.  

FYI all the MS products that I've seen do the same thing with <INSERT> <SYMBOL> Word, PowerPoint etc....

RE: Greek letters in Excel 2000

You can also use the Character Map utility that's usually in Start Menu|Programs|Accessories|System Tools.  It gives you a nice little preview of the characters so you don't have to guess what the result will be.

TTFN

RE: Greek letters in Excel 2000

(OP)
Thanks!

RE: Greek letters in Excel 2000

You can also use ASCII charactors with Alt key combinations:
Hold Alt, type the number, and release.
Here are a few that may be of interest. They do not show up in HTML format, so I won't display them here.
Alt-248, Alt-237, Alt-235
Alt-234, Alt-233, Alt-232
Alt-231, Alt-230, Alt-229
This is a little quicker for frequently used symbols.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: Greek letters in Excel 2000

°öäÙÈÖôµó - cool!

TTFN

RE: Greek letters in Excel 2000

Darn... they were there when I was typing them in ;-(

TTFN

RE: Greek letters in Excel 2000

That's how you do it!  I've been inserting the symbols in M$ Word, then I would Copy the symbol, and then Paste it into the Excel cell(s) as needed.

Later,
Ken

RE: Greek letters in Excel 2000

I tried the suggestion by dsi, but it is not working.
Is it because:
1. the excel is xp
2. it's the laptop??
help!
Thanks!

RE: Greek letters in Excel 2000

Luk-

On some keyboards, you have to use the other Alt key.

Sounds strange, but it matters.  



Remember...
       "If you don't use your head,
                       your going to have to use your feet."

RE: Greek letters in Excel 2000

If you do not need to perform functions with the letters, you can insert what you need using Microsoft Equation 3.0 (this is an add in to office that you might need to install depending how you have configured your set-up).

From the Excel toolbar pick; Insert; then Object; the Microsoft Equation 3.0

This starts a powerful tool that lets you write equations exactly as they would appear in a text book.  It includes just about everything one would ever use, including a help file that is pretty good.  You can even combine operations and the symbols would adjust automatically to look appropriate (you can have a fraction with a radical in the numerator and a triple integral in the denominator)

I use it regularly to show equations in both Excel and Word.  

If you do need to perform functions with the letters, I recommend the "Symbol" font.

RE: Greek letters in Excel 2000

(OP)
Thanks for all the tips!

RE: Greek letters in Excel 2000

Luk,

I tried the ASCII character codes and it wouldn't work for me either.  Then I found the trick is to use the numeric keypad (on a PC keyboard).  With our laptop, I had to set "Num Lock" and use the keys with the numbers in small boxes.  i.e. 2 corresponds to the 'K' key.

Give that a try.

RE: Greek letters in Excel 2000

Thanks siclic!
Now it works...
Cheers, Luk

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close