View Single Post
  #1   Report Post  
FirstVette52
 
Posts: n/a
Default Setting Precision when using &"Characters"& in a cell reference

I have a cell reference as follows:
=E4 &" "& B7 &"%"

E4 =SUM(T1:T9)/T11
B7 =F2/196

How do I restrict my answer to zero decimal places?
--
FirstVette52