Excel format question
Excel format question
(OP)
I am trying to type letters with ^ or - symbols directly above desired letters. In the insert function I am unable to find what I need. Does anyone know how to add these marks above text using Excel?? Or is it even possible?
Thanks in advance!!
Thanks in advance!!





RE: Excel format question
Otherwise you will need to install a font that has the characters you need.
RE: Excel format question
» Alt-0234 gets you e-circumflex (ê)
» Alt-0219 gets you U-circumflex (Û)
» Alt-0187 gets you a left chevron (»)
This is harder work in some ways, but there are some contexts in Excel where it is the only way to get such characters. Entering them into strings that form parts of formulæ (alt-0230) for example.
RE: Excel format question
By the way I think these are called, extended ASCII characters, rather than ANSI.
good luck ⌠╫ ╟ °
RE: Excel format question
RE: Excel format question
an other solution would be to get a french keyboard (or enable French keyboard on your windows language bar) as most of those letters are on the French keyboard. Beware it would be an azerty one though.
Cyril Guichard
Defense Program Manager
Belgium
RE: Excel format question
FrenchCAD,
In the Excel environment at least, it is less simple (but more powerful) than your referenced web site suggests. To give an example:
» If I enter alt-0200 I get E-acute (È).
» If I enter alt-200 I get a corner character (╚).
So the repertoire of available characters is larger.
I've never really understood what is going on here. Is it (pursuing RWF7437's comment above) the difference between ANSI and ASCII?
RE: Excel format question
I've just become acutely aware that I made a grave mistake.
Je ne parle pas le Français muy bueno.
RE: Excel format question
http://ascii-table.com/ansi-table.php
http://ascii-table.com/codepage.php?1252
Cyril Guichard
Defense Program Manager
Belgium
RE: Excel format question
RE: Excel format question
Cyril Guichard
Defense Program Manager
Belgium
RE: Excel format question
RE: Excel format question
The editor will open as a dotted line box in the Excel sheet and a toolbar. Select the mathematical formula characteristics from the toolbar. You can build very complex formulas by adding characteristics.
It's easier to use the full MathType software but the Microsoft version is okay.
RE: Excel format question
-- MechEng2005