Math formulas possible with overstrike characters?
 

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!

Math formulas possible with overstrike characters?
 

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!

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!