Forum Discussion
insert date when giving "OK" command
Hello everyone, How do I mark the date that I give "OK" in a cell to appear a specific text (in another cell) along with the date that was given that "OK"? For example. "paid on 10-10-2023"
Hello Hans,
Thanks for your support!
I followed the step by step you told me, but the date still does not appear. How do I "Set column E numeric format to custom format
"Paid on" dd-mm-yyyy "? like you said.
If there is a way in which I put OK in column D and in column E the date appears (without changing as the days go by), that's fine.
Thanks for your support!
I followed the step by step you told me, but the date still does not appear. How do I "Set column E numeric format to custom format
"Paid on" dd-mm-yyyy "? like you said.
If there is a way in which I put OK in column D and in column E the date appears (without changing as the days go by), that's fine.
Select column E, then click the arrow in the lower right corner of the Number group on the Home tab of the ribbon.
Select Custom in the Category list, then type
"Paid on"dd-mm-yyyy
in the Type box.
Click OK.
See the attached demo workbook. You'll have to allow macros when you open it.
