Formatting column with custom date format

frostym54

New Member
Joined
Nov 18, 2014
Messages
10
I have a worksheet with a column with date and time that I get from our IT showing all incoming and outgoing calls. The date and time column is formated to show Aug 30, 2019 7:15:22PM. I want to change the format to be mm/dd/yy hh:mm. When i highlight the column and go to custom and format the way I want and then hit enter, nothing happens until i click into each individual cell. Then it changes to the custom format. How can I get it to change to the new format without having to click in and out of each cell.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,493
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Try selecting the column and then pressing Ctrl+H to bring up the Find/Replace dialog, then enter / in both the Find box and the Replace box, and press Replace All.
 

frostym54

New Member
Joined
Nov 18, 2014
Messages
10
Try selecting the column and then pressing Ctrl+H to bring up the Find/Replace dialog, then enter / in both the Find box and the Replace box, and press Replace All.
I tried that and nothing happened. They are still in the format of

Aug 01, 2019 1:54:13 AM

I want them in this format:

<tbody>
</tbody>
01-Aug-19 01:54

<tbody>
</tbody>
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,493
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Sorry, misread your post. Use a colon in both the Find and Replace boxes instead of /
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,493
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Glad to help. :)
 

Forum statistics

Threads
1,084,749
Messages
5,379,620
Members
401,616
Latest member
YoSquidly

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top