View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MAJ0116 MAJ0116 is offline
external usenet poster
 
Posts: 1
Default Using a cell w/Alpha numeric characters in mulplication formula

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