+ Reply to Thread
Results 1 to 3 of 3

issue converting date to a spacific format

  1. #1
    Registered User
    Join Date
    10-22-2009
    Location
    Roanoke, indiana
    MS-Off Ver
    Excel 2010
    Posts
    94

    issue converting date to a spacific format

    Good Morning group,

    I am having a issue with custom formatting see below. Each month I bring a csv file inn with 500-600 items I have created a template to import it to however i need the date format changed as described below. Any HELP is greatly appreciated.
    Thanks

    What I would like to have is "YYYY-MM-DDThh:mm:ss-GMT" or the actually to show this: 2014-01-06T00:00:00-05:00,
    however when I apply it to the cells with the date in it I get this:"2013-01-10T00:00:00-1T". I am applying it to a cell that has "10-Jan-13" in it.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: issue converting date to a spacific format

    Try number format:

    yyyy-mm-ddThh:mm:ss"-GMT"
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    10-22-2009
    Location
    Roanoke, indiana
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: issue converting date to a spacific format

    Nope but thanks anyway. I am trying to get it to put the (utc -05:00) at the end and have it change to what ever zone the sheet is used in.

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: issue converting date to a spacific format

    Quote Originally Posted by komet12 View Post
    Nope but thanks anyway. I am trying to get it to put the (utc -05:00) at the end and have it change to what ever zone the sheet is used in.
    You won't achieve that through a number format - you'll need to use VBA. Excel has no native functions for converting times based on timezone.

+ 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. Converting from the 1904 date format to the 1900 date format without losing data
    By Patty McJorst in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2020, 12:53 PM
  2. issue with converting number to date need help!
    By fredderf81 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-09-2013, 11:17 AM
  3. Replies: 5
    Last Post: 02-08-2013, 11:06 AM
  4. Converting DATE format to GENERAL format?
    By timtim in forum Excel General
    Replies: 9
    Last Post: 08-19-2011, 02:38 AM
  5. converting date format to text format
    By membership in forum Excel General
    Replies: 4
    Last Post: 03-17-2010, 03:24 AM

Tags for this Thread

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