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

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.

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

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

"Theun4gvn" wrote in message
...
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.

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

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

--

HTH

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


"Paul B" wrote in message
...
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

"Theun4gvn" wrote in message
...
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.

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

right click sheet tabview codecopy/paste thisSAVE.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


--
Don Guillett
SalesAid Software

"Theun4gvn" wrote in message
...
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.