Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in a text cell
I need to show my date as 06-Dec-2005 in a text cell. Is it possible to have
a regular date format in a text cell. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in a text cell
If you format the cell as Text, then you'll have to type in what you
want--exactly the way you want to see it. If you don't format it as text, you could type the date in anyway that's a date, then use a custom format of: dd-mmm-yyyy (format|cells|number tab|custom category) Dajana wrote: I need to show my date as 06-Dec-2005 in a text cell. Is it possible to have a regular date format in a text cell. Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in a text cell
Assuming date in C1......
="My birthday is on " &TEXT(C1,"dd-mmm-yyyy") Gord Dibben Excel MVP On Tue, 6 Dec 2005 14:12:01 -0800, Dajana wrote: I need to show my date as 06-Dec-2005 in a text cell. Is it possible to have a regular date format in a text cell. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
extract name when a date in another cell gets near | Excel Worksheet Functions | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |