98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Time and date stamp
Time and date stamp
Resolved · Low Priority · Version Standard
Anthony has attended:
Excel Advanced course
Time and date stamp
Hi
Was wondering if you would be able to help me with a formula.
I have a worksheet that is filled in by users as they input invoices.
In Cell A8 i have written the following formula:
If(B8="","",NOW())
The idea is that if the user types an invoice number into B8 it will record the time and date they entered the record. This formula works for the first record but after i copy the formula down through column A if something is entered into B9 it will update A9 as also A8 which will distort the figures. Is there any way to stop this from happening?
Hope this makes sense, if not please let me know.
Many thanks
Tony
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Formst Excel to display leading zeroesSelect the cells that you want to have displaying leading zeroes. |