Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2013
    Posts
    2

    Question Unanswered: Excel 2007 change date format

    Hello,

    Currently my excel spreadsheet shows m/dd/yyy (example 9/15/2012). I would like it to show dd/mm/yyy (example 15/09/12). Is there anyway to do this without re-typing everything? I have selected the dates and tried to format the cells to "date" (before they were just showing "general") but it is not working.

    I tried =TEXT(A1, "dd/mm/yyyy") but I must be doing something wrong because it just keeps the format at 9/15/2012.

    Help! Thank you!
    Last edited by CutieBibs; 08-13-13 at 17:33. Reason: Added

  2. #2
    Join Date
    Feb 2013
    Posts
    15
    1. Select a cell to be formatted i specific date format.
    2. Right click and choose "Format Cells...".
    3. In the "Number" tab select "Custom" and type the format you want. For example: dd.mm.yyyy
    4. Click "OK" button.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •