+ Reply to Thread
Results 1 to 9 of 9

How to convert to uk date system

  1. 09-03-2018, 05:50 AM #1
    bananacitizen
    bananacitizen is offline
    Registered User
    Join Date
    12-30-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    74

    How to convert to uk date system

    Hi,
    How do I convert date column in attached sheet into UK date system? For example Sep 03, 2018 (Aug) into 03/09/2018? I tried normal date formatting method but didn't work. Any help greatly appreciated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-03-2018, 06:03 AM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,324

    Re: How to convert to uk date system 

    Please Login or Register  to view this content.
    Try this formula
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 09-03-2018, 06:06 AM #3
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How to convert to uk date system

    Select the column, got Data>Text columns... and pick Fixed width.

    Put a break after the date and on the 3rd step choose MDY from the Column data format dropdown.

    If you want to keep the month in the brackets insert a column after the release date column.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  4. 09-03-2018, 06:08 AM #4
    bananacitizen
    bananacitizen is offline
    Registered User
    Join Date
    12-30-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    74

    Re: How to convert to uk date system

    Thanks, tried it says there is errors in this formula
    Reply With QuoteRegister To Reply
  5. 09-03-2018, 06:17 AM #5
    bananacitizen
    bananacitizen is offline
    Registered User
    Join Date
    12-30-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    74

    Re: How to convert to uk date system

    Brilliant, Thanks lot
    Reply With QuoteRegister To Reply
  6. 09-03-2018, 06:32 AM #6
    bananacitizen
    bananacitizen is offline
    Registered User
    Join Date
    12-30-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    74

    Re: How to convert to uk date system

    Hi
    Just one thing I tried your method, but the year on all dates same like 2018?
    Reply With QuoteRegister To Reply
  7. 09-03-2018, 06:33 AM #7
    bananacitizen
    bananacitizen is offline
    Registered User
    Join Date
    12-30-2015
    Location
    england
    MS-Off Ver
    2010
    Posts
    74

    Re: How to convert to uk date system

    Quote Originally Posted by Norie View Post
    Select the column, got Data>Text columns... and pick Fixed width.

    Put a break after the date and on the 3rd step choose MDY from the Column data format dropdown.

    If you want to keep the month in the brackets insert a column after the release date column.
    Hi
    Just one thing I tried your method, but the year on all dates same like 2018?
    Reply With QuoteRegister To Reply
  8. 09-03-2018, 07:51 AM #8
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How to convert to uk date system

    When I tried what I suggested on the file you uploaded all the dates were converted properly and with the proper year.
    Reply With QuoteRegister To Reply
  9. 09-03-2018, 07:52 AM #9
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,324

    Re: How to convert to uk date system

    The formula in a xls file
    Attached Files Attached Files
    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. [SOLVED] Slice system date field and convert to US dates
    By rpinxt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-22-2018, 07:04 AM
  2. [SOLVED] Date conversion - Excel presents system report date incorrectly
    By Fred Johs in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-02-2017, 10:26 AM
  3. convert percentage into a letter grading system
    By thursday140 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2016, 08:08 AM
  4. CDate fails to convert when system in different locale
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2016, 06:19 AM
  5. [SOLVED] (Automation Error) How to retrive data between from date to system date using excel VBA
    By Kalpesh93 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2015, 06:50 AM
  6. Convert Base 10 to any other numeric system
    By Speshul in forum Tips and Tutorials
    Replies: 3
    Last Post: 09-15-2014, 02:23 PM
  7. [SOLVED] Counting the days positive or negative between a date (inserted value) to the system date
    By dafonso in forum Excel General
    Replies: 5
    Last Post: 10-02-2013, 09:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1