+ Reply to Thread
Results 1 to 1 of 1

How to change a unchageable date cell into a desired date format

  1. #1
    Registered User
    Join Date
    03-22-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    12

    How to change a unchageable date cell into a desired date format

    Hi. I am trying to change a large amount of cells which has the UK date format such as 15/06/1896 where it is June 15th in year 1896.

    I am trying to change these dates into this date format which is in the following US date format such as 06-15-1896 for all the relevant cells.

    However, the cells in the date format as 15/06/1896 do not chage at all no matter how I change the date format in the format cells option.

    I was told to use the following link:

    http://j-walk.com/ss/excel/files/xdate.htm

    and download the xdate.exe file and execute it, but I have the follwing errors:

    error2.png

    I would appreciate if I could know how I can solve this problem..

    Thank you very much.
    Last edited by erickwy; 03-22-2014 at 06:28 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to convert exported text date to desired date format with excel vba.
    By sktneer in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 10-03-2013, 01:08 AM
  2. Macro to change date value from one date format to another date format
    By RG12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2013, 04:51 AM
  3. Replies: 1
    Last Post: 11-01-2012, 10:37 AM
  4. [SOLVED] Combine Character and Date of desired format
    By Excel Dumbo in forum Excel General
    Replies: 3
    Last Post: 09-06-2012, 02:40 AM
  5. Not able to change date format into proper excel date format
    By excel5111987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2011, 08:19 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