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 |
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 |
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 |
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com