auto date
 

Is it possible to have a cell i.e F14 - auto date with the days current date
when you open the template?

Andy JL

auto date
 

Put =now() into the cell.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andy JL" wrote:

Is it possible to have a cell i.e F14 - auto date with the days current date
when you open the template?

Andy JL

auto date
 

Thanks works great but can it have it display just date without the time?

Andy JL

"galimi" wrote:

Put =now() into the cell.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andy JL" wrote:

Is it possible to have a cell i.e F14 - auto date with the days current date
when you open the template?

Andy JL

auto date
 

Format the cell to whatever you want to see.

CellsFormatNumberDate or Custom

Or use =TODAY()


Gord Dibben Excel MVP



On Fri, 18 Nov 2005 08:28:48 -0800, "Andy JL"
wrote:

Thanks works great but can it have it display just date without the time?

Andy JL

"galimi" wrote:

Put =now() into the cell.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andy JL" wrote:

Is it possible to have a cell i.e F14 - auto date with the days current date
when you open the template?

Andy JL

auto date
 

This is a very useful thread, but what if you only want the current date to
be put in when you click on the cell

"Gord Dibben" wrote:

Format the cell to whatever you want to see.

CellsFormatNumberDate or Custom

Or use =TODAY()


Gord Dibben Excel MVP



On Fri, 18 Nov 2005 08:28:48 -0800, "Andy JL"
wrote:

Thanks works great but can it have it display just date without the time?

Andy JL

"galimi" wrote:

Put =now() into the cell.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andy JL" wrote:

Is it possible to have a cell i.e F14 - auto date with the days current date
when you open the template?

Andy JL

auto date
 

Use CTRL + ; (semi-colon)

Otherwise you would need to use event code to enter today's date when you
clicked on the cell.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Const myRange As String = "A1"
On Error GoTo endit
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(myRange)) Is Nothing Then
Target.Value = Format(Date, "mm-dd-yyyy")
End If
endit:
Application.EnableEvents = True
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code"

Copy/paste into that module. Edit to suit.

Alt + q to return to the Excel window.


Gord Dibben MS Excel MVP

On Mon, 15 Sep 2008 02:15:00 -0700, fomula problems
wrote:

This is a very useful thread, but what if you only want the current date to
be put in when you click on the cell

"Gord Dibben" wrote:

Format the cell to whatever you want to see.

CellsFormatNumberDate or Custom

Or use =TODAY()


Gord Dibben Excel MVP



On Fri, 18 Nov 2005 08:28:48 -0800, "Andy JL"
wrote:

Thanks works great but can it have it display just date without the time?

Andy JL

"galimi" wrote:

Put =now() into the cell.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andy JL" wrote:

Is it possible to have a cell i.e F14 - auto date with the days current date
when you open the template?

Andy JL