Thread
:
Format problem ( SUM & "text")
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
Format problem ( SUM & "text")
=TEXT(SUM(A1:A10,"# ##0,00"" ft2""")
HTH
--
AP
"Ed" a écrit dans le message de news:
...
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
Reply With Quote