Question

  • Creator
    Topic
  • #2265397

    Date format in Excel 97

    Locked

    by jardinier ·

    I keep spreadsheets of various things, such as bank accounts, in Excel 97 (Office 97).

    The date format is:

    27/03/07

    I regularly backup these spreadsheets on floppy. I have recently transfered to another computer. Same OS 98 SE — same MS Office from same disc.

    I copied the spreadsheets to the other computer and now the date format throughout is:

    3/27/07

    I cannot find anything in the Excel help file which explains this or gives me the option to revert to the previous format which is the standard way of writing dates in Australia.

All Answers

  • Author
    Replies
    • #2585952

      Clarifications

      by jardinier ·

      In reply to Date format in Excel 97

      Clarifications

    • #2585925

      Computer Time, Not Exel

      by userdeletedbyrequest ·

      In reply to Date format in Excel 97

      Exel looks at the time the computer is set, this maybe your problem. double click the time in the lower right hand corner to fix the time issue

      • #2585798

        Totally wrong answer

        by jardinier ·

        In reply to Computer Time, Not Exel

        Now wouldn’t it be a nice change if people who don’t know the correct answer didn’t waste my time by making a random guess.

        [b]There is no option available to change the format of either the time or the date in that area.[/b]

        [b]HOWEVER[/b] I looked in Word Help and found that the date format could be altered in Regional Settings in Control Panel.

        [b]HOWEVER[/b] there is no option there either to set the format in the manner it showed on the other computer. There are a number of options, but not the one I want and am familiar with.

        This is one area where Macintosh is light years ahead of Windows. Both date and time formats can be customised to suit any preference.

        [b]HOWEVER[/b] I think I may have solved the mystery. Computer No 1 has Win 98 UPGRADE installed, with 98 SE on top of that. So the difference might have been in the 98 upgrade version as distinct from full 98.

Viewing 1 reply thread