Excel- 11/13/2017 10:01 PM to display as - 11/13/2017 22:01:00

Swati Pathak

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 ?

1 Reply

You don't need to any function, just follow these steps:


Step 1:

Select the cell or the range of cells that contain the dates to be changed.


Step 2:

Press Ctrl+1 and select Custom from Category list box.


Step 3:

In Type text box put this format:

m/d/yyyy h:mm:ss


Step 4:

Hit OK.



Related Conversations
Excel User Interface (UI) Freezing
Stuart-Signify in Excel on
3 Replies
Windows 10 1903 Group Policy Issues after OSD
techyluke in Windows 10 deployment on
13 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies