On Sun, 05 Jul 2015 20:39:36 -0400, GS wrote:

But did you try to print it?

When I said the records were wrong, my wife checked, and the data
was as she entered it. It was in printing that the entry was
changed.

It prints exactly as displayed whether I open the file in Excel 9,
10, 11, 12, or 14 on either of my XP Pro SP3, Win7 Pro, or Win8.1
machines!

Well then the version on my wife's computer can't be any of those,
because hers *did* behave like that.

For what it's worth, it came with MS Office 10.

Do you mean MS Office 2010, or MS Office 2002 (v10)? Regardless, I
tested with all versions from v9 to v14 across the 3 OSs I mentioned.
Are you sure she doesn't have it set up to only display 2-digit years?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion