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