Thread: Format number using CONCATONATE
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChasDavisIII
 
Posts: n/a
Default Format number using CONCATONATE
How do I use the folowing formula and show the number with a unit seperating
comma like 12,469?

=CONCATENATE(SUM(F7:F26)," Brick")
Reply With QuoteReply With Quote