View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Formatting cells

Gary

Yes it can. Sample formula...........

="Payment due " &TEXT(H15,"mmmm, d yyyy") & " " & TEXT(I15,"$#,##0.00")


Gord Dibben MS Excel MVP


On 14 Dec 2006 16:32:15 -0800, "GARY" wrote:

Can a formula contain expressions to format the result (i.e., currency
or numbers, with commas, with decimal-places, etc)?