| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Date in Cell with Text
I have a named range, DT, which contains a date value. I wish to display in
a cell: ="Revenue Account Summary As Of " & DT But I get "Revenue Account Summary As Of 39566". How can I format the Dt in the cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Date in Cell with Text
="Revenue Account Summary As Of " & TEXT(DT,"mm/dd/yyyy")
or if you like the European form use dd/mm/yyyy -- Gary''s Student - gsnu200782 "Mike H." wrote: I have a named range, DT, which contains a date value. I wish to display in a cell: ="Revenue Account Summary As Of " & DT But I get "Revenue Account Summary As Of 39566". How can I format the Dt in the cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format date & number within a cell containing text | Excel Discussion (Misc queries) | |||
| Cell format with Data Import (date appearing as text) | Excel Discussion (Misc queries) | |||
| text and date format in a cell | Excel Discussion (Misc queries) | |||
| Text and dates into one cell without loosing date format | Excel Discussion (Misc queries) | |||
| How to format cell with text and date. | Excel Discussion (Misc queries) | |||
Linear Mode
