View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
LurfysMa LurfysMa is offline
external usenet poster
 
Posts: 61
Default How to imbed a cell reference in a text field?

On Thu, 14 Dec 2006 06:20:01 -0800, Max wrote:

"LurfysMa" wrote:
=CONCATENATE("Cost at $",E7,"/hour.")


An alternative to try as well would be:
="Cost at "&TEXT(E7,"$#,##0.00") &"/hour"


Thanks.

That's the type of solution I was looking for, but couldn't find, when
I stumbled across the Concatenate function.

--
Running Excel 2000 SP-3 on Windows 2000