Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting some data from Access into Excel. Each record has a date
assigned with it and that is a key record. The date is showing up in Excel
as a long integer number, which is apparently how Access stores dates. I
need to convert the date back to a standard date format. I have tried
changing the format of the cell and that didn't work. Any ideas on how to
accomplish this?
 
What do the long integer numbers look like? (give several examples)

Biff
 
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

Columns formatted As Dates Are Exported as a Number to Text 1
Which is the best MBOX Converter Tool different formats conversion? 4
Why can't I convert Long date format to Short date 1
Date Formatting 2
Convert dates stored as text 2
Date Format (No Time) 2
Match, VLookup... who knows? 3
Changing a Date into a Value 1

Back
Top