access dates in excel, how to change format?

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: How to make the date format uniform ? 1
Weird date format problem 2
Preserving date format 1
date format 1
Excel 2003 keeps on changing the date that i entered. HELP PLEASE 1
Conditional formatting of date-cell - 2007 5
dd/mm/yy if i change to some other format 2
Date Formating Problem 1

Top