+ Reply to Thread
Results 1 to 12 of 12

Date Format Change

  1. 07-13-2016, 04:53 AM #1
    vjharry
    vjharry is offline
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Unhappy Date Format Change

    Hi,

    As per attached file can you please let me know how i can change format of below date.

    "Feb 3 2016 5:44PM "


    Thanks in Advance
    Attached Files Attached Files
    Click on (*), if you agree.
    Reply With QuoteRegister To Reply
  2. 07-13-2016, 04:55 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,565

    Re: Date Format Change

    In what way do you want to change the format? The dates in the attachment are in the same format ...
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-13-2016, 05:00 AM #3
    vjharry
    vjharry is offline
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Re: Date Format Change

    Yes they are in same format but not in Date format...
    Reply With QuoteRegister To Reply
  4. 07-13-2016, 05:00 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,565

    Re: Date Format Change

    I don't understand what you are asking. Please be clear. The column in the spreadsheet is set to date format.
    Reply With QuoteRegister To Reply
  5. 07-13-2016, 05:03 AM #5
    vjharry
    vjharry is offline
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Re: Date Format Change

    Quote Originally Posted by AliGW View Post
    I don't understand what you are asking. Please be clear.

    If you see that column Cell is that showing as Text ... But i want that to change in Date format

    For example Below date which is shown as

    "Feb 3 2016 5:44PM "

    I want to show this by "03-02-2016"
    Please let me know how it can be done.

    Thanks
    Reply With QuoteRegister To Reply
  6. 07-13-2016, 05:05 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,565

    Re: Date Format Change

    Try applying this custom format to your cells:

    mmm d yyyy h:mm AM/PM;@
    Reply With QuoteRegister To Reply
  7. 07-13-2016, 05:11 AM #7
    vjharry
    vjharry is offline
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Re: Date Format Change

    Quote Originally Posted by AliGW View Post
    Try applying this custom format to your cells:

    mmm d yyyy h:mm AM/PM;@
    Not working

    Tried...
    Reply With QuoteRegister To Reply
  8. 07-13-2016, 05:13 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,565

    Re: Date Format Change

    It's working here. Explain how you have tried ...
    Reply With QuoteRegister To Reply
  9. 07-13-2016, 05:16 AM #9
    vjharry
    vjharry is offline
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Re: Date Format Change

    Quote Originally Posted by AliGW View Post
    It's working here. Explain how you have tried ...

    I just go to format cell and in custom formatting applied that format.
    Can you please send that attachment by applying that same in another cell
    Reply With QuoteRegister To Reply
  10. 07-13-2016, 05:45 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,565

    Re: Date Format Change

    See cell A21.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 07-13-2016, 05:59 AM #11
    vjharry
    vjharry is offline
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Re: Date Format Change

    Quote Originally Posted by AliGW View Post
    See cell A21.

    I want to Change those cell's format which are From A2 to A20 only...
    file which you have sent .... i also can do ..but it will not serve my purpose
    Reply With QuoteRegister To Reply
  12. 07-13-2016, 06:16 AM #12
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,565

    Re: Date Format Change

    Well, I'm sorry, but I don't have time to do it for you. All of those cells have the same formatting applied to them. You need to explain clearly what you mean by "it will not serve my purpose", and hopefully someone else will help you out.
    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. Show Error when a cell with number format change to date format
    By delroba in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2015, 02:57 AM
  2. [SOLVED] Date formula - Change Format to YYYYMMDD from Exported Format
    By haleakala17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2014, 03:22 PM
  3. [SOLVED] help on vba code to change the error date format as standard format mm/dd/yyyy
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2013, 01:10 AM
  4. Excel:How change the textbox format from text to date format?
    By inpetto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2013, 08:23 AM
  5. Macro to change date value from one date format to another date format
    By RG12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2013, 04:51 AM
  6. Not able to change date format into proper excel date format
    By excel5111987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2011, 08:19 AM
  7. Userform date format reverting back to us format on change event
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2009, 12:34 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