Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there something like Word's "CREATEDATE" function in Excel?
I've created a lovely invoice in Excel for my company. When I generate a new
invoice from the template it puts in the date using the TODAY() function, but unfortunately this updates if I ever open the invoice again to look at it. In Word there is a "CREATEDATE" function which inserts the date that the file was created first, and never after does it change. Is there any way to accomplish this same task in Excel? Thanks, Michael mleenheer @ yahoo.com |
#2
|
|||
|
|||
ML, Keyboard shortcut to date stamp is put your cursor in the cell you want and push -- ctrl ; --(thats ctrl and semicolon) Time stamp would be -- ctrl shift ; -- (ctrl shift semicolon) This help ? Dave - ML - Wrote: I've created a lovely invoice in Excel for my company. When I generate a new invoice from the template it puts in the date using the TODAY() function, but unfortunately this updates if I ever open the invoice again to look at it. In Word there is a "CREATEDATE" function which inserts the date that the file was created first, and never after does it change. Is there any way to accomplish this same task in Excel? Thanks, Michael mleenheer @ yahoo.com -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=389913 |
#3
|
|||
|
|||
I'm not aware of any such function, but there is another way to freeze the
date. When you open a new invoice from the template, click on the date cell and press these keys: Ctrl and semicolon. This will change the entry to a permanent date. "- ML -" <- ML wrote in message ... I've created a lovely invoice in Excel for my company. When I generate a new invoice from the template it puts in the date using the TODAY() function, but unfortunately this updates if I ever open the invoice again to look at it. In Word there is a "CREATEDATE" function which inserts the date that the file was created first, and never after does it change. Is there any way to accomplish this same task in Excel? Thanks, Michael mleenheer @ yahoo.com |
#4
|
|||
|
|||
ML, If your interested in a macro you could use something like this 'Insert current date in active cell. Sub InsertDate() With ActiveCell .Value = Now .NumberFormat = "mm/dd/yy" End With End Sub If you use it with something like a Button, Logo, Pic etc to run the macro, it will not update automatically, only when you click the button. You could target a cell insead of "on selection". This help ? Dave - ML - Wrote: I've created a lovely invoice in Excel for my company. When I generate a new invoice from the template it puts in the date using the TODAY() function, but unfortunately this updates if I ever open the invoice again to look at it. In Word there is a "CREATEDATE" function which inserts the date that the file was created first, and never after does it change. Is there any way to accomplish this same task in Excel? Thanks, Michael mleenheer @ yahoo.com -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=389913 |
#5
|
|||
|
|||
You could use an Event Procedure. I put this into the template's workbook code.
Right click on the Excel icon to the left of the File Menu. Pick View Code. Change the drop-down on the left to Workbook. Make sure Private Sub Workbook_Open() shows on the right drop-down. You should change A1 to whatever cell you want the date to appear in. This macro will insert the current date into the cell specified for every file created from the template, unless there is something else in the cell already. This should stop the date from changing if you open the file up in the future...as long as you never delete the date. Private Sub Workbook_Open() Dim x As Range Set x = Range("A1") If x.Value = "" Then x.Value = Date End Sub -- tj "- ML -" wrote: I've created a lovely invoice in Excel for my company. When I generate a new invoice from the template it puts in the date using the TODAY() function, but unfortunately this updates if I ever open the invoice again to look at it. In Word there is a "CREATEDATE" function which inserts the date that the file was created first, and never after does it change. Is there any way to accomplish this same task in Excel? Thanks, Michael mleenheer @ yahoo.com |
#6
|
|||
|
|||
Thanks all!! Appreciate the help.
Michael "tjtjjtjt" wrote: You could use an Event Procedure. I put this into the template's workbook code. Right click on the Excel icon to the left of the File Menu. Pick View Code. Change the drop-down on the left to Workbook. Make sure Private Sub Workbook_Open() shows on the right drop-down. You should change A1 to whatever cell you want the date to appear in. This macro will insert the current date into the cell specified for every file created from the template, unless there is something else in the cell already. This should stop the date from changing if you open the file up in the future...as long as you never delete the date. Private Sub Workbook_Open() Dim x As Range Set x = Range("A1") If x.Value = "" Then x.Value = Date End Sub -- tj "- ML -" wrote: I've created a lovely invoice in Excel for my company. When I generate a new invoice from the template it puts in the date using the TODAY() function, but unfortunately this updates if I ever open the invoice again to look at it. In Word there is a "CREATEDATE" function which inserts the date that the file was created first, and never after does it change. Is there any way to accomplish this same task in Excel? Thanks, Michael mleenheer @ yahoo.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
triadic combinations of words | Excel Worksheet Functions | |||
how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) | |||
how to change numbers into words, | Excel Discussion (Misc queries) | |||
Creating a Microsoft Words document from an existing Excel spreads | New Users to Excel |