> At 17:28 01/06/2007 -0400, Kenn Goutal wrote: >>In Calc, I want to be able to store the VALUE of the current date -- >>whatever it is -- >>into a particular cell, such that at some future date it will still >>show today's date. >> >>That is, if today is June 1, 2007, I want to store *that*, >>not an expression that today evaluates to that >>and tomorrow evaluates to June 2, 2007 >>and next week evaluates to June 8, 2007. >> >>I mean, I can probably look somewhere else on my monitor, note the time, >>and type it in by hand, but that (for me) is error-prone. >> >>So I'd rather roll up whatever would do this into a macro of some kind, >>bind it to a key or an icon on a toolbar, and use that. >> >>Is this possible? > > Here's a sequence that will get today's date as a fixed value into a cell: > > o Enter =TODAY() into the cell. > o Copy the contents of the cell. > o Paste the cell contents back into the same cell, but using Paste > Special... (from the Edit or context menus). In the Paste Special > dialogue box, remove the tick from "Paste all" if necessary, and then > ensure that "Numbers" is ticked and "Formulae" is *not* ticked. > > What this pastes back into the cell is a constant value rather than > the formula that created it. Note that you will probably need to > format the cell as a date in your required format in order that the > value is displayed properly as a date and not as the integer that > Calc stores as a code for the date. You could include that > formatting in this sequence or perhaps apply it to a column or region > of your worksheet separately. > > I'll leave you to translate this into a macro. > > I trust this helps. > > Brian Barker
If you want this as a macro, I think that my free macro document AndrewMacro.odt has an example of this. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
