Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date when exporting from access to excel
hi,
Ihave exported a table to excel from access. There is a column which looks like this "18/12", "23/10" etc. It is defined as text in access and i can't change that. When i exported it in excel, it kept this format but when i try to change it (format cells-date-some format(e.q. 01-oct) ) it doesn't do anything. The funny thing about it is that whenn i double click in a cell to edit it, it automaticly changes to the desired format. There are a lot of data and i can't do it one by one. Has anyone got any ideas. thanks -- Panos |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date when exporting from access to excel
Hi Panos
Try this Enter 1 in a empty cell Copy the cell Select all text dates cells EditPaste Special Choose Multiply -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Panos" wrote in message ... hi, Ihave exported a table to excel from access. There is a column which looks like this "18/12", "23/10" etc. It is defined as text in access and i can't change that. When i exported it in excel, it kept this format but when i try to change it (format cells-date-some format(e.q. 01-oct) ) it doesn't do anything. The funny thing about it is that whenn i double click in a cell to edit it, it automaticly changes to the desired format. There are a lot of data and i can't do it one by one. Has anyone got any ideas. thanks -- Panos |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date when exporting from access to excel
Try Data/ Text to columns/ Delimited/ Next/ Next, then at step 3 of 3 select
column data format as Date: DMY, and finish. -- David Biddulph "Panos" wrote in message ... hi, Ihave exported a table to excel from access. There is a column which looks like this "18/12", "23/10" etc. It is defined as text in access and i can't change that. When i exported it in excel, it kept this format but when i try to change it (format cells-date-some format(e.q. 01-oct) ) it doesn't do anything. The funny thing about it is that whenn i double click in a cell to edit it, it automaticly changes to the desired format. There are a lot of data and i can't do it one by one. Has anyone got any ideas. thanks -- Panos |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to date when exporting from access to excel
David that worked perfectly. Thanks. Ron i didn't try your solution but
thanks for your attention. -- Panos "David Biddulph" wrote: Try Data/ Text to columns/ Delimited/ Next/ Next, then at step 3 of 3 select column data format as Date: DMY, and finish. -- David Biddulph "Panos" wrote in message ... hi, Ihave exported a table to excel from access. There is a column which looks like this "18/12", "23/10" etc. It is defined as text in access and i can't change that. When i exported it in excel, it kept this format but when i try to change it (format cells-date-some format(e.q. 01-oct) ) it doesn't do anything. The funny thing about it is that whenn i double click in a cell to edit it, it automaticly changes to the desired format. There are a lot of data and i can't do it one by one. Has anyone got any ideas. thanks -- Panos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exporting data from access to excel | Excel Discussion (Misc queries) | |||
Exporting data from access to excel | Excel Worksheet Functions | |||
Exporting an Excel Chart into Access | Charts and Charting in Excel | |||
Exporting fields from access to excel | Excel Discussion (Misc queries) | |||
importing/exporting from access to excel | Excel Discussion (Misc queries) |