+ Reply to Thread
Results 1 to 4 of 4

Date format 21-Jan-21

  1. 01-21-2021, 12:16 AM #1
    ellyna
    ellyna is offline
    Registered User
    Join Date
    12-07-2020
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    11

    Date format 21-Jan-21

    May i know why does my date format are different ?

    Capture.PNG


    Please Login or Register  to view this content.
    Last edited by alansidman; 01-21-2021 at 12:51 AM.
    Reply With QuoteRegister To Reply
  2. 01-21-2021, 06:29 AM #2
    rorya
    rorya is offline
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Date format 21-Jan-21

    Cell formats and formats applied to a textbox are not related to each other at all. Change the cell format to whatever you want.
    Rory
    Reply With QuoteRegister To Reply
  3. 01-27-2021, 03:24 AM #3
    ellyna
    ellyna is offline
    Registered User
    Join Date
    12-07-2020
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    11

    Re: Date format 21-Jan-21

    I tried but it still not working.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-27-2021, 04:44 AM #4
    rorya
    rorya is offline
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Date format 21-Jan-21

    Your column B is set to a US date format, which is not the same as in your picture. Change it to reflect what you actually want.
    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. 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. [SOLVED] Converting Date & Time (General format) to Date (Date format)
    By supremenuts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2017, 12:55 PM
  3. [SOLVED] Date format issue shows as Jan 8, 2015 (Non date format) but want DD/MM/YYYY - Help
    By seash in forum Excel General
    Replies: 4
    Last Post: 04-29-2015, 08:36 AM
  4. Date Format Of User PC Changes Display format date of Excel File after update
    By waihar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2014, 03:09 AM
  5. Converting Twitter date format to standard Excel date format to use with WEEKDAY function
    By dharmis in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-08-2013, 11:06 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. Column Range with date Format MM/DD/YYYY independate of sys date Format
    By gaursh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 03:31 AM

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