| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
access dates in excel, how to change format?
I have imported data from Access. When I try to work with the date the
format can not be changed. It stays in mm/dd/yy hrs/min/sec format and can not be changed by excel. Is there a way to change this format to get these cells to act and sort in the same manner as the ones where I manually enter the date? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
access dates in excel, how to change format?
If they are not reacting to a change in format, then excel is probably
treating them as text. Try this... 1. Copy an empty cell 2. Select the cells you want to change to a date 3. Edit-Paste Special 4. Select "add" 5. Reformat the cells as a date "dccoffin" wrote: I have imported data from Access. When I try to work with the date the format can not be changed. It stays in mm/dd/yy hrs/min/sec format and can not be changed by excel. Is there a way to change this format to get these cells to act and sort in the same manner as the ones where I manually enter the date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to change the default number format in Excel? | Excel Discussion (Misc queries) | |||
| How do I change the format in a excel drop box? | Excel Discussion (Misc queries) | |||
| Linking Large Access Table into Excel | Links and Linking in Excel | |||
| How do I change format of page numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
| EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) | |||
Linear Mode
