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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
sorry! a small correction! 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-Nov-2005"? thks & regds! via135 via135 Wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
Hi
One way, with your date in A1, enter in B1 =--A1 FormatCellsNumberCustom dd=mmm-yyyy Regards Roger Govier via135 wrote: sorry! a small correction! 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-Nov-2005"? thks & regds! via135 via135 Wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
Select cell and DataText to ColumnsNextNext
Data Format TypeDate DMY Finish. Gord Dibben Excel MVP On Fri, 23 Dec 2005 12:10:43 -0600, via135 wrote: sorry! a small correction! 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-Nov-2005"? thks & regds! via135 via135 Wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
One fairly easy solution, select the cell/column with the text dates,
do datatext to column, click next twice and under column data format select date and from the dropdown select DMY and click finish, this will change it to a numerical date and then you can just use custom format like dd-mmm-yyyy -- Regards, Peo Sjoblom "via135" wrote in message ... sorry! a small correction! 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-Nov-2005"? thks & regds! via135 via135 Wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
Hi Roger,
that would work if the OP is using UK regional settings but not if he uses US since it will return a value error -- Regards, Peo Sjoblom "Roger Govier" wrote in message ... Hi One way, with your date in A1, enter in B1 =--A1 FormatCellsNumberCustom dd=mmm-yyyy Regards Roger Govier via135 wrote: sorry! a small correction! 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-Nov-2005"? thks & regds! via135 via135 Wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
if your date is in cell A1 in the next cell type =datevalue(A1), then go to
format--cell-- date--choose type 14-Mar-2001 ( it is the last item). Hope it works. happy Holidays! "Gord Dibben" wrote: Select cell and DataText to ColumnsNextNext Data Format TypeDate DMY Finish. Gord Dibben Excel MVP On Fri, 23 Dec 2005 12:10:43 -0600, via135 wrote: sorry! a small correction! 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-Nov-2005"? thks & regds! via135 via135 Wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
This won't work if the OP is using US regional settings which I suspect
he/she might do -- Regards, Peo Sjoblom "Nikki" wrote in message ... if your date is in cell A1 in the next cell type =datevalue(A1), then go to format--cell-- date--choose type 14-Mar-2001 ( it is the last item). Hope it works. happy Holidays! "Gord Dibben" wrote: Select cell and DataText to ColumnsNextNext Data Format TypeDate DMY Finish. Gord Dibben Excel MVP On Fri, 23 Dec 2005 12:10:43 -0600, via135 wrote: sorry! a small correction! 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-Nov-2005"? thks & regds! via135 via135 Wrote: 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date..!!
hi thks everyone for ur immediate response! via135 Peo Sjoblom Wrote: This won't work if the OP is using US regional settings which I suspect he/she might do -- Regards, Peo Sjoblom "Nikki" wrote in message ... if your date is in cell A1 in the next cell type =datevalue(A1), then go to format--cell-- date--choose type 14-Mar-2001 ( it is the last item). Hope it works. happy Holidays! "Gord Dibben" wrote: Select cell and DataText to ColumnsNextNext Data Format TypeDate DMY Finish. Gord Dibben Excel MVP On Fri, 23 Dec 2005 12:10:43 -0600, via135 wrote: sorry! a small correction! 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-Nov-2005"? thks & regds! via135 via135 Wrote: 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 |
Reply |
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 |