| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Issues Access to Excel
I have to cut n paste a series of rows from Access to Excel.
In the access database, there is a date field like 26/08/2006. It pastes into Excel OK I then want to change the way it looks to a format yyyymmdd. It needs to bejust a text cell and not date type. However - I cannot get it to lose its access format and consequently can't get the data in the way I want it. Any ideas please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
| How do I fix a date format error in Excel? | Excel Discussion (Misc queries) | |||
| excel - access query - date range | Excel Discussion (Misc queries) | |||
| Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Threaded Mode
