| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Math formulas possible with overstrike characters?
Thanks--I'll give it a try today.
"Joel" wrote: You can use the equation editor to write an equation but you wouldn't be abble to extract the actual numbers. the formula look real good Use worksheet menu Insert - Object - Equation editor for simple subscript fonts just change the font type the letter/numbers you want then got to format menu - cells - font click the superscript or subscript box and then continue typing "Peter" wrote: I've been building spreadsheets as a math teacher to make extra worksheets for my algebra students, and want to move from simple one line equations into ones with exponents and complex fractions. I want to do such graphics within a single cell. I note that the character set includes superscripts and subscripts for the numbers 0 through 9 (for example if you type =char(178) in a cell you get a superscripted 2, and =char(179) is a superscripted 3). Is there a wa of overstriking characters into the same cell? I once accidently did this by writing a header on the spreadsheet that spilled over into the cells below it, so theoretically it should be doable. This, along with concatenations of adjacent cell's characters, would enable me to build complex formulas in single spreadsheets. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a way to overstrike characters in excel | Excel Discussion (Misc queries) | |||
| Formulas dealing with searching for characters | Excel Worksheet Functions | |||
| Excel Math formulas | Excel Discussion (Misc queries) | |||
| need list of free math formulas in excel | Excel Worksheet Functions | |||
| Characters and Formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
