Re: $$Excel-Macros$$ =Now() Keep from changing

2011-05-08 Thread rajan verma
Agree with Stdv(i). On Sun, May 8, 2011 at 12:42 AM, Bob bobandrich...@comcast.net wrote: If I enter the Customer in B27 I'd like for todays date to be entered in F27 automatically. How would you keep the date from changing the next day, each time the workbook is opened? Thanks in advance!!!

$$Excel-Macros$$ =Now() Keep from changing

2011-05-07 Thread Bob
If I enter the Customer in B27 I'd like for todays date to be entered in F27 automatically. How would you keep the date from changing the next day, each time the workbook is opened? Thanks in advance!!! -- -- Some

Re: $$Excel-Macros$$ =Now() Keep from changing

2011-05-07 Thread STDEV(i)
instead of writing =NOW() or =TODAY() in a cell select a cell then press Ctrl + ;(for FIXED today's date ) press Ctrl + Shift + :(for Fixed Now time ) On Sun, May 8, 2011 at 2:12 AM, Bob bobandrich...@comcast.net wrote: If I enter the Customer in B27 I'd like for todays date to be