View Single Post
  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Thu, 18 Nov 2004 21:27:01 -0800, "ez123"
wrote:

in excel how to display results of a function and text in the same cell, for
example:
The total is <here come the results of a function


If the text is always the same, you could use a Custom Format.

For example, with you formula in A1, select A1 and Format/Cells/Number Custom
Type: "The result is "0.00




--ron