+ Reply to Thread
Results 1 to 4 of 4

Change date format

  1. #1
    Registered User
    Join Date
    09-18-2019
    Location
    Canberra, Australia
    MS-Off Ver
    Excel
    Posts
    3

    Change date format

    Hello,

    I have completed a large document that has many dates on it and the dates are currently listed in a DD.MM.YYYY format and I was wanting to change all the dates to a DD/MM/YYYY format.

    I have tried to alter them with cell format but have not had any luck. Can someone please help me with this issue and let me know how to perform this action if it is possible.

    Thank you

  2. #2
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: Change date format

    Try use Find and Replace to replace all dot (.) by slash (/).

  3. #3
    Registered User
    Join Date
    09-18-2019
    Location
    Canberra, Australia
    MS-Off Ver
    Excel
    Posts
    3

    Re: Change date format

    Thank you huuthang_bd!

  4. #4
    Valued Forum Contributor
    Join Date
    12-14-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    439

    Re: Change date format

    You are welcome. Thank you for added reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change format to date format if cell populated with a date
    By Lbelden78 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-22-2019, 08:26 AM
  2. 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
  3. [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
  4. [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
  5. 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
  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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1