Vista - EXCEL 2000 AND WINDOWS VISTA

I'm finding that cell formatting (eg, dates) will no longer work in Excel
2000. Whether it is an existing spreadsheet or a new one, cell formatting
does not work, and all dates entered are treated as text. This applies
whether the cell formatting is done before or after the date is entered.

It does appear to be a Vista/Excel 2000 conflict of some sort as it did not
happen until after I got Vista. And I've just opened (from a Windows XP
computer on the same network) some of the offending files, and the problem
does not exist.

Has anyone else experienced this? Is there a workaround available?

--
Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.

Lindsay Graham wrote:
Someone reading this group might know the answer (and I'm sorry but I
don't); however, the best place for you to ask this question is in the
Excel newsgroup. That's where the Excel experts hang out.

microsoft.public.excel

Malke
--
MS-MVP
Elephant Boy Computers
www.elephantboycomputers.com
Don't Panic!

Hello Lindsay,

I am running Office 2000 on Vista. There are some things like Outlook that don't work. Also some functionality in other programs, but I don't have any problem formatting cells. One thing that I have done is to go to the program file (I believe a shortcut will also work), right click and select the compatibility tab. Tick the 'Run this program in compatibility mode for' and select windows 2000 from the drop down list.

Hope it works for you.

Thanks, Malke. I started the thread on an Excel newsgroup, got lots of
help, but no solutions. When I realised that it is (or at least appears to
be) a Vista-caused problem, I thought I might get more joy here. Still
hoping.

Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.

"Malke" <malke@xxxxxx> wrote in message
news:e40kkM7yIHA.2340@xxxxxx

Thanks for the suggestion, "garysgold". I selected both Windows XP and
Windows 200, but neither made any difference. I have not yet rebooted, but
will let you know if that helps at all.

I'm not using Outlook (and I have heard there are some compatibility
problems there). But what functionality do you have problems with in other
programs?

--
Lindsay Graham
Canberra, Australia
---------------------------------------------
Please reply only to the list/newsgroup so that all may benefit.

"garysgold" <guest@xxxxxx-email.com> wrote in message
news:40792d749d27d4085ac72d1b2a49c251@xxxxxx-gateway.com...

Haven't found anything within a single program in office2K so far. Noticed
that some links between Exel and Access don't seem to work. I was only
playing as I don't use Access anymore. Great prog. just more than I need.

Good luck,
garysgold

"Lindsay Graham" <LDGraham@xxxxxx> wrote in message
news:Olllf27yIHA.420@xxxxxx