Using a cell w/Alpha numeric characters in mulplication formula
With 14.3 in A1 and 185 in B1 enter in C1
=TEXT("["&A1&" hrs @ "&B1,"$##.00")&" /hr]"
Gord Dibben MS Excel MVP
On Fri, 9 Feb 2007 14:01:00 -0800, MAJ0116
wrote:
Trying to create multple rows with each showing
[14.3 hrs @ $185/hr] (each row different hours and $rate)
It's necessary for us to have the brackets showing, but a cell with [14.3 in
it is not recognized as a number - same thing applies to the $185/hr
Appreciate any assist
|