If I use this in a template, how can I get it to save the correct day's date
each time? Do I have to copy, paste special - values?

CTRL-; (Control semicolon) enters today's date as a fixed number

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Amy" wrote in message ...
| If I use this in a template, how can I get it to save the correct day's date
| each time? Do I have to copy, paste special - values?

Yes.

OR enter the date using CTRL + semi-colon to get a static date.

OR code the date as static when you save the file.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 12:56:00 -0800, Amy wrote:

If I use this in a template, how can I get it to save the correct day's date
each time? Do I have to copy, paste special - values?

Thanks, but is there a formula that I can use so the users of my template
never have to enter a date?

AS

"Gord Dibben" wrote:

Yes.

OR enter the date using CTRL + semi-colon to get a static date.

OR code the date as static when you save the file.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 12:56:00 -0800, Amy wrote:

If I use this in a template, how can I get it to save the correct day's date
each time? Do I have to copy, paste special - values?

Amy

See John McGimpsey's site for a non VBA approach using a circular reference.

http://www.mcgimpsey.com/excel/timestamp.html

Would your users object to having event code add a static date when the workbook
is opened?

Is your template a true template file? As in template.xlt?

You could add this code to Thisworkbook module in your Template.xlt file

Private Sub Workbook_Open()
With Sheets("Sheet1").Range("A1")
If .Value = "" Then
.Value = Format(Now, "ddmmmyy")
End If
End With
End Sub

Whenever a new book is created from your template, the date will be entered in
A1 of Sheet1.

When you save that book as template1.xls, the date will be frozen.


Gord

On Wed, 23 Jan 2008 14:35:01 -0800, Amy wrote:

Thanks, but is there a formula that I can use so the users of my template
never have to enter a date?

AS

"Gord Dibben" wrote:

Yes.

OR enter the date using CTRL + semi-colon to get a static date.

OR code the date as static when you save the file.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 12:56:00 -0800, Amy wrote:

If I use this in a template, how can I get it to save the correct day's date
each time? Do I have to copy, paste special - values?

This actually puts a value into the cell and excel may change the format to
something it likes better.

This may be better:

Option Explicit
Private Sub Workbook_Open()
With Sheets("Sheet1").Range("A1")
If .Value = "" Then
.value = date 'doesn't include the time
.numberformat = "ddmmmyy"
end if
End With
End Sub

Gord Dibben wrote:

Amy

See John McGimpsey's site for a non VBA approach using a circular reference.

http://www.mcgimpsey.com/excel/timestamp.html

Would your users object to having event code add a static date when the workbook
is opened?

Is your template a true template file? As in template.xlt?

You could add this code to Thisworkbook module in your Template.xlt file

Private Sub Workbook_Open()
With Sheets("Sheet1").Range("A1")
If .Value = "" Then
.Value = Format(Now, "ddmmmyy")
End If
End With
End Sub

Whenever a new book is created from your template, the date will be entered in
A1 of Sheet1.

When you save that book as template1.xls, the date will be frozen.

Gord

On Wed, 23 Jan 2008 14:35:01 -0800, Amy wrote:

Thanks, but is there a formula that I can use so the users of my template
never have to enter a date?

AS

"Gord Dibben" wrote:

Yes.

OR enter the date using CTRL + semi-colon to get a static date.

OR code the date as static when you save the file.


Gord Dibben MS Excel MVP

On Wed, 23 Jan 2008 12:56:00 -0800, Amy wrote:

If I use this in a template, how can I get it to save the correct day's date
each time? Do I have to copy, paste special - values?



--

Dave Peterson