View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Equations and Text in same Cell

yes. you could incorperate the round() funciton.
post your formula

regards
FSt1

"Eric" wrote:

I am using Excel to write a program. I would like to incorporate text within
the same cell as the result of an equation but the I cannot control the
number of decimal places that the output displays. I've tried using the
Number tab in the Format Cell feature but nothing changes.

Is there a way to control the number of decimal places when you are
combining text with the results of an equation?