Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
if i am having a date in a cell as 30/11/2005 but formatted in text, what's the procedure to change the same to date format as "30-Mar-2005"? thks & regds! via135 -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=495816 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a text string into a date? | Excel Worksheet Functions | |||
Converting number or text to a Date Format | New Users to Excel | |||
Macro to convert text to date | Excel Worksheet Functions | |||
Change Text Data to Date | Excel Discussion (Misc queries) | |||
EXTRACT TEXT FROM A DATE | Excel Worksheet Functions |