+ Reply to Thread
Results 1 to 15 of 15

changing the date format

Hybrid View

  1. 03-24-2015, 06:37 AM #1
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: changing the date format

    Hi,

    On the Cell, Press Ctrl+1 to open Format Cells Dialogue Box, Select the last Option "Custom" and Paste this - yyyymmdd

    Click OK..
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  2. 03-24-2015, 06:49 AM #2
    EmileEA
    EmileEA is offline
    Registered User
    Join Date
    01-13-2015
    Location
    Amsterdam
    MS-Off Ver
    2013
    Posts
    16

    Re: changing the date format

    Quote Originally Posted by msexcelathome View Post
    Hi,

    On the Cell, Press Ctrl+1 to open Format Cells Dialogue Box, Select the last Option "Custom" and Paste this - yyyymmdd

    Click OK..
    Hi,

    Sam problem as with Special-K his answer. This changes the format to yyyy0125.
    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] Formula for Changing date format 3-12-13 to format d-mm-yy.
    By UNAB in forum Excel General
    Replies: 2
    Last Post: 04-08-2013, 03:52 PM
  2. [SOLVED] Changing Multiple sheet names by wk ending date for yr but need specific name/date format
    By kedeling in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2013, 02:40 PM
  3. Need help changing date to a sortable date format
    By slicksilver79 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 12-15-2011, 10:44 AM
  4. Formula required for date without changing the date format
    By suryaprasad in forum Excel General
    Replies: 1
    Last Post: 01-28-2009, 08:04 AM
  5. Changing date serial numbers to date format
    By rdunne in forum Excel General
    Replies: 1
    Last Post: 04-14-2005, 08:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1