| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cells
Can a formula contain expressions to format the result (i.e., currency
or numbers, with commas, with decimal-places, etc)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
| How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Linear Mode
