Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Date Format Won't Change

  1. #1
    Join Date
    28th May 2005
    Posts
    41

    Date Format Won't Change

    Hello-

    Can anyone tell me why I can't change the format of the date column, (the first column), of this spreadsheet? It doesn't seem to be responding to any date format changes I try to make.

    Also, I tried to combine some cells with a formula like =A2&B2&D2, and all I saw in the cell that should have had the result was the formula itself. (Note, this example isn't represented on the attachement. I deleted that column before posting. Just looking for suggestions on why that might happen).

    I'd appreciate any suggestions.

    Thanks,
    Tim
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,713

    Re: Date Format Won't Change?

    I entered a new date as per my date system in Windows (dd/mm/yy) and you format took fine. Other dates I re-entered and they changed fine too.

    See valid Excel Dates & Times

  3. #3
    Join Date
    28th May 2005
    Posts
    41

    Re: Date Format Won't Change

    Thanks...

    That did it...

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    25th April 2006
    Posts
    890

    Re: Date Format Won't Change

    I have had this issue also. I donít know why, but you have to double click the cell to get rid of whatever format is applied. As a work around, copy any blank cell, select all of the dates in column A, right click, paste special, Add. Not even sure what that is doing, but it will cause your dates to revert to a number format and you will be able to format these numbers/dates anyway you like.
    Last edited by bryce; November 7th, 2006 at 11:00.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    28th May 2005
    Posts
    41

    Re: Date Format Won't Change

    Thanks. It's always fun to try to edit a report that someone else created. When I first starting working on this report, the creator had hundreds of dollar values in the report with the period and comma transposed; ($1.000,00) instead of $1,000.00. I didn't notice and tired to divide those cells and the FUN began...

    Then when I got to trying to sort and format the dates... well, here I am...

    I'm affraid to see what I'll run into next.

    Thank you both for the good advice.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Change Date Format
    By dgr in forum EXCEL HELP
    Replies: 17
    Last Post: June 6th, 2006, 23:52
  2. Replies: 2
    Last Post: March 3rd, 2006, 02:38
  3. Change one date format to another using VBA
    By dew in forum EXCEL HELP
    Replies: 14
    Last Post: October 23rd, 2004, 00:37
  4. Change date format
    By wroth in forum EXCEL HELP
    Replies: 2
    Last Post: May 16th, 2003, 11:03

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
  •  
porno