+ Reply to Thread
Results 1 to 3 of 3

Excel date question

  1. 10-14-2008, 07:12 PM #1
    roasthawg
    roasthawg is offline
    Registered User
    Join Date
    07-22-2008
    Location
    auburn
    Posts
    74

    Excel date question

    Ok, here's my problem. I have a spreadsheet and the dates were manually entered in general format so that today's date would read: 20081014

    I need to find a way to convert this number into the actual date format that excel recognizes...any ideas? Thanks!
    Reply With QuoteRegister To Reply
  2. 10-14-2008, 07:17 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    =TEXT(A1, "0000\/00\/00") + 0 and format as a date.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 10-14-2008, 07:22 PM #3
    roasthawg
    roasthawg is offline
    Registered User
    Join Date
    07-22-2008
    Location
    auburn
    Posts
    74
    Quote Originally Posted by shg View Post
    =TEXT(A1, "0000\/00\/00") + 0 and format as a date.
    Beautiful...works like a charm! Thanks so much for the help...that was much easier than I was making it!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. DBF to Excel - date conversion problem
    By dai50 in forum Excel General
    Replies: 4
    Last Post: 08-26-2009, 11:46 AM
  2. Date Formula in Excel
    By Excel Newbie05 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-26-2008, 11:53 AM
  3. subtract dates in Excel, but one is not in date format.
    By dcoates in forum Excel General
    Replies: 7
    Last Post: 06-04-2007, 12:27 PM
  4. Advanced Excel Code or validation question...
    By aclevermind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2007, 06:13 PM
  5. Urgent HELP for Formula for a date problem on Excel!
    By flip_360_2002 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2006, 12:14 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1