Previous Topic Next Topic

Date Format TODAY

Solved/Closed
Signer - Feb 14, 2010 at 11:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 23, 2010 at 07:37 AM
Hello,

I have an invoice with a date format "TODAY". If I create an invoice today, it assigns today's date. If I open the invoice tomorrow, it assigns tomorrow's date to it. I need it to stay as the original date created. How do I fix my invoice to do that?

Thanks

Signer
Related:

2 responses

Answer 1 / 2
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
Feb 23, 2010 at 04:15 AM
Hello,

To insert the current date in a selected cell : just press the Ctrl key and the ; key at the same time.

Best regards
1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 23, 2010 at 07:37 AM
neat shortcut. Thanks for sharing
0
Answer 2 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 14, 2010 at 07:44 PM
as soon as today's date is entered
edit-copy todays date on itself with edit-pastespecial -values-ok

you can prepare(or create) a macro for this
0
Signer
Feb 22, 2010 at 02:43 AM
Thank you so much. This worked great. You are a lifesaver. I tried researching this in Excel Help and could not figure it out.
0

Similar discussions

Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses
Pc Game show unsupported signal check your output device
Shravanshinde2424 -
dwebb -

1 response
How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response
Problem connecting certain websites
PaulZero -
Anonymous -

90 responses