Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Richard Rosell
 
Posts: n/a
Default auto entry of a date

I have created a template for a worksheet I use frequently to record client
information. I am interested in finding a function that will permit me to
automatically insert the date I first use create a document based on the
template (i.e. a create date) that does not change when I open the document
on subsequent occassions.

Does any one have a suggestion as to how I might accomplish this.

Thanks

Richard


  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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

"Richard Rosell" wrote:

I have created a template for a worksheet I use frequently to record client
information. I am interested in finding a function that will permit me to
automatically insert the date I first use create a document based on the
template (i.e. a create date) that does not change when I open the document
on subsequent occassions.

Does any one have a suggestion as to how I might accomplish this.

Thanks

Richard



  #3   Report Post  
Richard Rosell
 
Posts: n/a
Default

Thanks very much Frank.

Richard

"Frank Kabel" wrote in message
...
Hi
see:
http://www.mcgimpsey.com/excel/timestamp.html

"Richard Rosell" wrote:

I have created a template for a worksheet I use frequently to record
client
information. I am interested in finding a function that will permit me
to
automatically insert the date I first use create a document based on the
template (i.e. a create date) that does not change when I open the
document
on subsequent occassions.

Does any one have a suggestion as to how I might accomplish this.

Thanks

Richard





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Skipping and protected cells Dave Peterson Excel Discussion (Misc queries) 6 January 27th 05 11:35 PM
Date issue between Windows and Macintosh version dlg1967 Excel Discussion (Misc queries) 4 January 19th 05 03:51 PM
assign auto number and auto date Krit Kasem Excel Discussion (Misc queries) 2 January 14th 05 02:55 AM
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM
Time Format Auto Entry AM and PM BulaMan Excel Discussion (Misc queries) 1 December 15th 04 09:30 AM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"