yes click the the applicable column header whhich should higlight the entire column and then format cells on the drop down box which will give you a few date formats which do not include the time
Further to our chat on linkedIn I have set up a similar text box with a live date and the :08:00 time tag does not show - just the date. I can see no function in the Edit box that allows me to make this show. So how you have achieved your result is a mystery. Try deleting the box and adding again.
Member for
8 years 4 monthsyes click the the applicable
yes click the the applicable column header whhich should higlight the entire column and then format cells on the drop down box which will give you a few date formats which do not include the time
Hope this helps
Dan
Member for
19 years 10 monthsHi NatalieFurther to our chat
Hi Natalie
Further to our chat on linkedIn I have set up a similar text box with a live date and the :08:00 time tag does not show - just the date. I can see no function in the Edit box that allows me to make this show. So how you have achieved your result is a mystery. Try deleting the box and adding again.
Best regards
Mike Testro