Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 26th 06, 05:52 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 1
Default How to update dating?

I currently use Office 2003 including most of excel sheets. But I still
the old excel templates (e.g., invoice, purchasing order, etc) from
97office excel on 03Excel program. The old templates has our company logo
and it automatically updated to the current date. It no longer does with
03Excel program. When the 97 templates was opened, they still shows old
date with the year 2004. So, I got to type the current date. This
becomes a slightly inconvenience. I would like to know how to fine tune
the "date" to autoupdate to our current date whenever I open the 97 excel
templates.

BTW, I found that the 03invoice required the manual typing of date. So I
concluded that 97 templates are still great if I could be able to fine tune
as mentioned above. TIA. Craig



  #2   Report Post  
Old October 28th 06, 08:09 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 207
Default How to update dating?

Craig,
Have you tried this in the cell that you want the date:
"=NOW()" without the ""

"Craig" wrote:

I currently use Office 2003 including most of excel sheets. But I still
the old excel templates (e.g., invoice, purchasing order, etc) from
97office excel on 03Excel program. The old templates has our company logo
and it automatically updated to the current date. It no longer does with
03Excel program. When the 97 templates was opened, they still shows old
date with the year 2004. So, I got to type the current date. This
becomes a slightly inconvenience. I would like to know how to fine tune
the "date" to autoupdate to our current date whenever I open the 97 excel
templates.

BTW, I found that the 03invoice required the manual typing of date. So I
concluded that 97 templates are still great if I could be able to fine tune
as mentioned above. TIA. Craig





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
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Adding a row to worksheet does not update cell references in another. blausen Excel Worksheet Functions 5 February 25th 06 10:14 PM
Excel Links Update TracyB Links and Linking in Excel 0 February 21st 06 02:48 PM
options to update automatic links Werner Rohrmoser Excel Worksheet Functions 0 November 10th 05 01:58 PM
Prompt to update links Werner Rohrmoser Links and Linking in Excel 0 November 3rd 05 10:47 AM


All times are GMT +1. The time now is 09:33 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017