Excel Question

[Le Pen]

Hello Chaps,

I'm running Excel95 and want to know if I can insert todays date into a spreadsheet without typing it in. Ie. using something like the lastUpdated thingy???

Thanks

LP

[rickity]

=now() would seem to provide an answer, nothing needed in the brackets.

[Le Pen]

Thaks
Spot on

LP

[spannersatcx]

or you can also put =today() which will be slightly different in that the time will be 00:00 rather than the time now!:ok:

[Tinstaafl]

That should work in a template? If so, is it possible to have it freeze the date once the file is saved as a .XLS?

[Agent86]

If you just want to enter the date and NOT have it update everytime you open the workbook (as it will if you use +Now() )

just type Control + semicolon ie
hold control key done and press the ; key

If you want the time just hold control and shift and press the same key ie control + colon

Search the excel help for keyboard shortcuts for more

MAx

[Le Pen]

This is all brilliant.......


BUT

I want to put the date in by using a Button/Macro....
So, I can do that with either =now() or =today() but I dont want it to update every day. just keep the day it was first entered.


Control ; works well but can I do that as a macro?


Thanks

LP

[Agent86]

Ahhh, I see what you want.

All you need to do is make a macro and enter this line

ActiveCell.Value = Format(Now(), "dd/mm/yyyy")

Change the format to what you want or format the particular cell.

If you want the date to go into a specific cell and not the active cell use this

Cells(x, y).Value = Format(Now(), "dd/mm/yyyy")

where x is the row number and y is the column number. You can't use the column letter in this function

Use the forms toolbar to add a button and create/link the associated macro.

MAx