Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 14th 05, 07:21 PM
Jackie
 
Posts: n/a
Default Changing Dates in Excel

When I open a file, the dates keep changing to the current date. How do I
stop this?

  #2   Report Post  
Old January 14th 05, 07:25 PM
Bob Phillips
 
Posts: n/a
Default

It must be a formula (=TODAY()).

You need to input the dates (Ctrl-, or use VBA to set them.

What does the spreadsheet do?

--
HTH

Bob Phillips

"Jackie" wrote in message
...
When I open a file, the dates keep changing to the current date. How do I
stop this?



  #3   Report Post  
Old January 14th 05, 08:09 PM
Jackie
 
Posts: n/a
Default

When I open a file with a previous date it changes it to the current date. I
need to know how to turn it off so I can keep the previous date?

"Bob Phillips" wrote:

It must be a formula (=TODAY()).

You need to input the dates (Ctrl-, or use VBA to set them.

What does the spreadsheet do?

--
HTH

Bob Phillips

"Jackie" wrote in message
...
When I open a file, the dates keep changing to the current date. How do I
stop this?




  #4   Report Post  
Old January 14th 05, 08:16 PM
Bob Phillips
 
Posts: n/a
Default

I think that was what I answered.

--
HTH

Bob Phillips

"Jackie" wrote in message
...
When I open a file with a previous date it changes it to the current date.

I
need to know how to turn it off so I can keep the previous date?

"Bob Phillips" wrote:

It must be a formula (=TODAY()).

You need to input the dates (Ctrl-, or use VBA to set them.

What does the spreadsheet do?

--
HTH

Bob Phillips

"Jackie" wrote in message
...
When I open a file, the dates keep changing to the current date. How

do I
stop this?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 crashes when changing fonts. Ross Excel Discussion (Misc queries) 3 January 22nd 05 12:54 AM
Entering dates in Excel 2002 DickG Excel Discussion (Misc queries) 3 January 9th 05 02:56 PM
Recognizing weekends and changing to weekdays in Excel hanauer Excel Discussion (Misc queries) 2 January 8th 05 02:13 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Can I get email alerts when dates in excel are nearing? lucrecat Excel Discussion (Misc queries) 2 December 14th 04 05:14 AM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017