Along the same lines as Biff suggested,
if you're required to input in B1 a text-phrase, say: X $2.00
then you could have in C1: =A1*SUBSTITUTE(B1,"X $","")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"accounting beginner" <accounting wrote
in message ...
What I am trying to have it look like in the end is a little different. I
probably didn't explain it very well the first time. What did first was
input A1: 200, B1: $2.00, and C1: =A1*B1. The thing works but the teacher
says I need to figure out how to make B1 look like "X $2.00" and still
have the C1 formula work properly and not give a #VALUE! error. It is
supposed to look like a typical vertical multiplication normally done on
paper the old fashioned way.

Does anyone know a way to make this work?