Formatting cells

GARY · Dec 15, 2006

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

Gary''s Student · Dec 15, 2006

Yes.

The TEXT() function does exactly what you want. See Excel Help.

Gord Dibben · Dec 15, 2006

Gary

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

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

Gord Dibben MS Excel MVP