Results 1 to 16 of 16

Change text date to normal date

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Amsterdam
    MS-Off Ver
    2010
    Posts
    21

    Change text date to normal date

    Hi,
    My name is Marc and I hope somebody can help me creating a VBA for my problem.
    I have included a file with the problem. See the Sheet Movies_seen.

    So in column “I” (Created) each cell has a date and time as a text string, it looks like this:
    Sun Aug 24 04:30:24 2014
    I want to replace this text date and time, into a normal date. This has to be in the same cell (sheet and column).

    For example: Sun Aug 24 04:30:24 2014 will look like: 24-8-2014 (first the day, then month and last the year, separated by a “-“.

    Only the date is of importance to me, the rest of the text and time of the cell can be ignored/deleted. The length of the column, in this example to row 89, is a variable.

    Hope my explanation is clear, if not feel free to contact me so I can explain some more.
    Thanks in advance for all your help.
    Marc
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change date format from text to date
    By maym in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-02-2017, 08:03 PM
  2. [SOLVED] Macro to change text date into normal date
    By mark888 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-20-2017, 03:59 AM
  3. Replies: 2
    Last Post: 01-31-2017, 10:00 PM
  4. [SOLVED] How to change text date (eg. July) to actual date format?
    By kellyfirth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2015, 09:49 AM
  5. Change text date 22OCT2013 to actual date
    By grattis in forum Excel General
    Replies: 14
    Last Post: 12-19-2013, 08:32 AM
  6. Replies: 3
    Last Post: 07-11-2009, 12:39 AM
  7. Change text to date and check against date in cell
    By RW in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2006, 11:30 AM

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