View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed
 
Posts: n/a
Default Format problem ( SUM & "text")

Hello, I have a cell in which I have as a formula

=SUM(A1:A10)&" ft2"

and I have a similar formula in other cells, some have as a result 2 decimal
places, others have 5 others 6 and so on, and I can't find a way to make them
all have 2, any ideas?

,thanks