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

Agree with Stdv(i). On Sun, May 8, 2011 at 12:42 AM, Bob 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!!! > > -- > >

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

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 wrote: > If I enter the Customer in B27 I'd like for todays date to be entered > in F27 automat

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

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 imp