View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default 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.