- last edited on
using excel 2007 I want my date - 11/13/2017 10:01 PM to display as - 11/13/2017 22:01:00
I tried text(), datevalue() but no luck. can someone help ?
You don't need to any function, just follow these steps:
Select the cell or the range of cells that contain the dates to be changed.
Press Ctrl+1 and select Custom from Category list box.
In Type text box put this format: