Multiplication in one cell

Is there a formula where I can input a number in a cell and get the sum of
that number X $4.20 .
Example
Cell a1
If i typed in 5 I would get $21.00
I tried #*$4.20= but it doesnt work
any ideas

Need to Multiply within one cell wrote:
> Is there a formula where I can input a number in a cell and get the sum of
> that number X $4.20 .
> Example
> Cell a1
> If i typed in 5 I would get $21.00
> I tried #*$4.20= but it doesnt work
> any ideas


You're asking for a circular reference. A cell that changes itself. I don't
believe it can be done simply. You'd have to use VBA trapping to sense somebody
typing in that one cell and then modify it I guess. It's probably more trouble
and effort learning programming on your part than it's worth.

Any reason you can't just put:

[B1] = A1*4.20

Bill