Dates keep changing!

Feb 27th, 2002, 08:24 PM

I have a spreadsheet that I want to put the date it was created in a cell - quite simply using TODAY() - thats not the problem. I want that to be the date that stays there. Everytime I open the spreadsheet it updates the date to the day I opened it - BUT I want the original date.

What formula / way can I do this?

Thanks

Simon

Paul B · Feb 27th, 2002, 08:30 PM

Use control and ; to put the date in it want change. =today() will change to show the current day

[ This Message was edited by: Paul B on 2002-02-27 19:31 ]

Chris Davison · Feb 27th, 2002, 08:31 PM

Quote:

On 2002-02-27 19:24, Anonymous wrote:
I have a spreadsheet that I want to put the date it was created in a cell - quite simply using TODAY() - thats not the problem. I want that to be the date that stays there. Everytime I open the spreadsheet it updates the date to the day I opened it - BUT I want the original date.

What formula / way can I do this?

Thanks

Simon

Hi SImon,

CNTRL and ; will add the date (well, it does on mine)

I suppose you could then protect that cell if needed

abrownbear · Feb 28th, 2002, 10:26 AM

If the date should always stay wouldn't you just type the date into the cell?

Chris Davison · Feb 28th, 2002, 12:56 PM

Quote:

On 2002-02-28 09:26, abrownbear wrote:
If the date should always stay wouldn't you just type the date into the cell?

Yeppers, good point : but if you don't know the date you'd fiddle around searching for a newspaper or a calender, of hovver your mouse over the time in the bottom of the right of your screen then type it in

or just hit CNTRL ; in Excel, the application that's open and running right infront of me when I'm confronted with this "problem".

I have to add though, I do know today is the 28th of February, but only cos it's payday at last

yayyyy me !!

o/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 08:24 PM	#1
Guest Posts: n/a	I have a spreadsheet that I want to put the date it was created in a cell - quite simply using TODAY() - thats not the problem. I want that to be the date that stays there. Everytime I open the spreadsheet it updates the date to the day I opened it - BUT I want the original date. What formula / way can I do this? Thanks Simon

Feb 27th, 2002, 08:30 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Use control and ; to put the date in it want change. =today() will change to show the current day [ This Message was edited by: Paul B on 2002-02-27 19:31 ]

Feb 28th, 2002, 10:26 AM	#4
abrownbear New Member Join Date: Feb 2002 Location: Frederick, MD Posts: 12	If the date should always stay wouldn't you just type the date into the cell?