Forum Discussion
Date and Time formatting issues
Hello, I am having trouble getting the Date and Time to show correctly in the table view, it is only showing in the formula bar. So, when my macro grabs the data from that cell it looks like 0.2286...
How do I do this? This is not something I've had to do before
Select D6.
On the Home tab of the ribbon, in the Number group, click on the drop-down arrow in the Number Format box, and select Short Date (or Long Date if you prefer).
Select E6.
This time, select Time from the Number Format drop-down.
Result: