How do I Format a cell to make 1=$3.00 per cell then total?

[Guest]

How do I Format a cell to make 1=$3.00 per cell then total,
So if user puts 2 it will then equal $6.00.

 

[Paul B]

Theun, how about in another cell, put you number in A1 and this in another
cell =A1*3

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Bob Phillips]

or just multiply the SUM formula by 3 and format as currency.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Don Guillett]

right click sheet tab>view code>copy/paste this>SAVE.works row2 or below in
col A

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column <> 1 Then Exit Sub
Application.EnableEvents = False
If IsNumeric(Target) Then Target = Target * 3
Application.EnableEvents = True
End Sub