Problem with Excel Dates

[Ron Rosenfeld]

I don't follow what you mean when you say the "date format in my
workbook" because it's the same workbook being opened from a network
location.

That's why I tried to clarify by writing the "default" date format in my followup post. If the cell is formatted as General, the appearance of a date entered by CTRL-; will match the DEFAULT date format in the workbook, which will change depending on the WRS of the machine on which the workbook is being displayed. So even though it's the same workbook, the default date format can vary.

 

[GS]

That's why I tried to clarify by writing the "default" date format in
my followup post. If the cell is formatted as General, the
appearance of a date entered by CTRL-; will match the DEFAULT date
format in the workbook, which will change depending on the WRS of the
machine on which the workbook is being displayed. So even though
it's the same workbook, the default date format can vary.

Okay, got it! That's what I suspected you were saying so thanks for
confirming...

--
Garry

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