Results 1 to 12 of 12

How to convert unusual date number to a date format

Threaded View

  1. 05-29-2019, 01:09 PM #7
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to convert unusual date number to a date format

    Another way:

    A
    B
    C
    2
    190501
    01 May 2019
    		 B2: =--TEXT(A1, "2\000-00-00")
    Last edited by shg; 05-29-2019 at 02:44 PM.
    Entia non sunt multiplicanda sine necessitate
    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. [SOLVED] Convert/Format Date to Serial Number not Date number.
    By rakotonirinas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2019, 12:26 PM
  2. Unusual Date Format - need a fix
    By simon4amiee in forum Excel General
    Replies: 61
    Last Post: 01-08-2015, 11:00 AM
  3. Convert Number into date format
    By Chieps in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 07-09-2013, 01:41 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. Convert date from date format to number format
    By althea10 in forum Excel General
    Replies: 2
    Last Post: 02-17-2011, 10:54 AM
  6. convert date number to date format
    By nygwnj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2007, 02:15 PM
  7. convert number to date format
    By Lesley in forum Excel General
    Replies: 4
    Last Post: 07-12-2006, 04:25 PM

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