Hi!

This really doesn't make any sense, but:

A1 = 10
B1 = * 5

=A1*SUBSTITUTE(B1,"*","")

=A1*MID(B1,2,255)

Biff

-----Original Message-----
In an accounting spread sheet I need to set up three
cells to show a
calculation in a specific way. The first cell is the
first number to be
multiplied. The second cell is supposed to have the
multiplication symbol
and the number to multply by. The third cell is to be a
formula cell in
which the multiplication takes place and the results are
shown. I don't
understand how my accounting teacher expects me to make
the second cell. If
I show the multiplication number then the formula cell is
messed up. Does
anyone have a suggestion. I thought about putting the
multiplication sign
off in its own cell but the teacher told us it should
only take up three
cells.
.