+ Reply to Thread
Results 1 to 2 of 2

Excel Date Formatt Issue

  1. #1
    Registered User
    Join Date
    04-25-2008
    Posts
    1

    Question Excel Date Formatt Issue

    I have a worksheet containing client data along with several dates(3 per column). About half of the dates are before 1900 so its not an issue, the others however, as you know, excel is storing them as a number, not a date, ex 39440 instead of 12/24/2007. My issue arises when I attempt to import this sheet in to Access. Access does not recognize the digits as a date, and will not import the data. Is there a workaround for this, or any way to keep Excel from storing the data as a number? Thanks for you help in advance!!!

  2. #2
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    If you format those columns as text and then insert the dates, it will erase the number format, but you will be unable to perform any operations based on dates.

    If you wish to maintain the dates for calculation purposes and use the date for access you can use a helper column with the formula:
    =TEXT(A1,"dd/mm/yyyy") It will convert those dates into text.
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1