Date format in Excel 97

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

The date format is:


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:


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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

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

Collapse -

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.

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

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

HOWEVER 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.

HOWEVER 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.

Collapse -

I Understand

by UserDeletedByRequest In reply to Totally wrong answer

i didn?t understand what you mean i thought you meant that it was giving you the wrong time!

Related Discussions

Related Forums