ExcelBanter - Formatting cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting cells (https://www.excelbanter.com/excel-discussion-misc-queries/122748-formatting-cells.html)

GARY

Formatting cells

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

Gary''s Student

Formatting cells

Yes.

The TEXT() function does exactly what you want. See Excel Help.
--
Gary's Student

"GARY" wrote:

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

Gord Dibben

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)?

All times are GMT +1. The time now is 09:28 PM.