+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Excel date format issue (convert?)

  1. 06-08-2011, 09:43 PM #1
    Chris.db
    Chris.db is offline
    Registered User
    Join Date
    06-08-2011
    Location
    NY
    MS-Off Ver
    Excel 2007
    Posts
    2

    Excel date format issue (convert?)

    I have data arround 10.000 columms and they have different date format as I need.

    They have

    20101205 230100
    20101205 230200

    they are general format, bud when I change it to date format I get only ####


    I need format like this:

    1.1.2011 0:00
    1.1.2011 0:08

    Can me somebody help how to make it ?

    Thx you very much in forward
    Reply With QuoteRegister To Reply
  2. 06-08-2011, 11:33 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Excel date format issue (convert?)

    Explain how you get
    1.1.2011 0:08
    from
    20101205 230100
    Show how each part of the original maps to the desired result.
    Ben Van Johnson
    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)

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