| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formating within a text cell
How can I format the date to display "March 1,2010" in the following formula?
="Volume moved between February 10, 2010 and "&TODAY()&" as determined" current result is = Volume moved between February 10, 2010 and 40238 as determined |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Formating within a text cell
="..." & text(today(), "mmmm d, yyyy") & "...."
Rob wrote: How can I format the date to display "March 1,2010" in the following formula? ="Volume moved between February 10, 2010 and "&TODAY()&" as determined" current result is = Volume moved between February 10, 2010 and 40238 as determined -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating a cell containing a date | Excel Worksheet Functions | |||
| Excel 2007 General Formating Unwanted Text to Date Conversion | Excel Discussion (Misc queries) | |||
| formating text cell paragraphs | Excel Discussion (Misc queries) | |||
| formating cell with TEXT data type | Excel Discussion (Misc queries) | |||
| condition formating word in text cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
