+ Reply to Thread
Results 1 to 4 of 4

Want to convert Date format

  1. 01-20-2022, 05:49 PM #1
    Max4f
    Max4f is offline
    Registered User
    Join Date
    01-20-2022
    Location
    USA
    MS-Off Ver
    2019
    Posts
    1

    Want to convert Date format

    Hi,

    I want to convert this date format

    2022-01-20 00:00:00.089Z to this 1/20/2022 0:00

    2022-01-20 00:00:00.089Z this date column starts from Cell A2 and converted dates should be in cell B2

    Sample file is attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-20-2022, 06:12 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Want to convert Date format

    Power Query Solution

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 01-20-2022, 06:13 PM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,440

    Re: Want to convert Date format

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 01-20-2022, 06:20 PM #4
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,440

    Re: Want to convert Date format

    With Excel 365, you can SPILL the formula like this:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    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] How to convert the unix date format to excel date format
    By sivaksekar in forum Excel General
    Replies: 1
    Last Post: 08-15-2016, 03:33 AM
  2. i have to convert the csv file date format to excel date format
    By arindamsenaxa in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-17-2015, 03:37 AM
  3. [SOLVED] Require vba or formula for convert general format data in date format
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2013, 03:53 AM
  4. Convert date and time in serial number format to text format
    By nda13112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2013, 02:45 PM
  5. Cannot convert date (which is in text format) to date in numeric format
    By geniuspro in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-19-2012, 09:21 AM
  6. Need Formula/VBA Code to convert date in String Format to Normal Date format
    By Karthik Sen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2012, 04:54 AM
  7. [SOLVED] Date Format Question- convert into a usable date format.
    By Josh O. in forum Excel General
    Replies: 1
    Last Post: 02-10-2005, 06:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1