Results 1 to 14 of 14

Custom Number Format: Convert to Date (yyyy-mm-dd)

Threaded View

  1. 10-25-2017, 01:22 PM #1
    xtinct2
    xtinct2 is offline
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    163

    Custom Number Format: Convert to Date (yyyy-mm-dd)

    Hi,

    I have a sheet w/ multiple columns that list dates. However the dates are written in the format of '6012017' (June 1st, 2017), and '11012016' (November 1st, 2016).
    This type of format seems to be 'mddyyyy' -- where the month could be 1 or 2 digits, the day is always 2 digits, and the year is always 4 digits.

    I know how I would manipulate this via a formula, but for this exercise I can't go that route.

    *** What Custom Number Format (in the 'Format Cells' dialogue box) should I input to convert all columns to to the 'YYYY-MM-DD' format? ***

    Is this possible?

    Thank you!
    Last edited by xtinct2; 10-25-2017 at 01:27 PM.
    Reply With QuoteRegister To Reply
« 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. Help require to change a year format to custom yyyy-yyyy format
    By mso3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-23-2015, 01:04 AM
  2. [SOLVED] Convert NUMBER Series entered as TEXT To DATE FORMAT mm/dd/yyyy
    By jobie804 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-05-2014, 02:38 PM
  3. [SOLVED] How to Convert date format ( DD/MM/YYYY) into MM/YYYY
    By PRADEEPB270 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2014, 07:25 AM
  4. convert date in yyyy/mm/dd format
    By abraham30 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-12-2013, 05:40 AM
  5. [SOLVED] Convert date format to (dd/mm/yyyy)
    By nur2544 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-11-2013, 09:40 AM
  6. [SOLVED] Convert Date Format from yyyy-mm-dd to dd mmm yy using VBA
    By longbow007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2012, 07:36 AM
  7. [SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB
    By Boormo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2012, 05:48 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