Insert date in cell but ..

[michele]

Hi, I have template for invoice that compile the cell date automatically
=today() but it's a problem if I open the document in a different date
because change cell contenent based on a function today. I want, if it is
possible, a template that use a formula to calcutate a value but in a new
document there're only the results not formula.
Thank's in advice

 

[Pete_UK]

In the template you can have the function TODAY( ), but then when you
set it up for a new invoice you should fix the value of this function.
To do this, click <copy> Edit | Paste Special | Values (check) then OK
and <enter> or <esc>. Then save the file with a different name so that
it does not overwrite the template.

Hope this helps.

Pete

 

[Pete_UK]

Michele emailed me directly with:

I don't want that my customer must do all this things.
thaks

If you are developing the template for the customer, then you could
record a macro while you do the actions listed above, i.e. click on the
cell containing the TODAY( ) function and <copy> Edit | Paste Special |
Values (check) then OK and <enter> or <esc>, as well as the beginning
of the File | Save As routine, then the macro could be allocated to a
button so that your client would only need to click the button when the
invoice is complete and specify where the file should be saved to and
the filename.

Hope this helps further.

Pete

 

[Guest]

or possibly:

You could just have the user enter the date like this: ' Ctrl+; '

Regards,
GS