Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel doc when sent, displays wrong date

Status
Not open for further replies.

greenarrow

IS-IT--Management
Aug 26, 2001
4
US
Gang-

Hope you can help. I have a user who's sending an Excel doc that's dated 7/24/03, but when another user (just one) recieves it, it's stating that the file is from 7/25/03. I've checked to make sure the time zone and clock are correct on the recieving machine, and it looks okay.

What could cause this?

Thanks-

Green Arrow --->
 
Hi,

Chances are the Date was set with a Date Field that reflects the CURRENT DATE.

Right click on the offending Date and select Edit Field and you'll probably see what kind of Field Property it has.

hope this helps :)

Skip,
Skip@TheOfficeExperts.com
 
Skip-

Thanks! I'll give it a shot!

GreenArrow --->
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top