Date From Access

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hi,

I have a database in MS Access 97 that i want to export data into Excel
to produce graphs. The date apear as DD/MM/YYYY but i want it to show
i.e 27-Jan-2005 to enable me to sort in date order. When i right click
and format cells it says that the date format is already in the format
that i want, but this is not the case. I have discovered that if i
double click on the cell the DD/MM/YYYY format changes to the format.
This is going to be very time consuming as i have thousands of rows to
format.

Anyone any ideas how to over come this problem.

Thanks

Fiona
 
Copy your ACCESS "table," "query" or whatever has the data you want
Then when you do a Paste into EXCEL do a "PASTE" - "SPECIAL" and the
Select "TEXT." Then you should be able to select your EXCEL column an
then change the format to what you want
 
You must log in or register to reply here.

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

How to enter a date in DD-MM-YYYY format 2
date format convert 2
Excluding Friday & Saturday from the calculation 1
Getting MM-DD HH:MM out of Julian date 4
Default date format 4
Form Control Calendar date will not change its format 1
Date Format Problem. 2
Forcing a date entry format of dd/mm/yyyy 1

Back
Top