Revise cells to just show date & not time

MrWonderfull

New Member
Joined
Jun 9, 2016
Messages
45
I have the following report that I downloaded from our external database. I need the Original Upload column to only display the date - just as it shows in the first cell and not the time.

Without me having to go line-by-line and manually revising is there a faster way of editing this?

dates_pic.jpg
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Marcílio_Lobão

Well-known Member
Joined
Oct 7, 2013
Messages
712
Platform
  1. Windows
MrWonderfull, Good afternoon.

Possibly this date came as TEXT when it was imported.

Try this one:

1) Format this column as mm/dd/yyyy
2) Put a number 1 at any cell or select any cell that show you a number 1.
3) Copy it (CTRL C)
4) Special Paste --> Multiplication --> OK

Is that what you want?
I hope it helps.
 

MrWonderfull

New Member
Joined
Jun 9, 2016
Messages
45
MrWonderfull, Good afternoon.

Possibly this date came as TEXT when it was imported.

Try this one:

1) Format this column as mm/dd/yyyy
2) Put a number 1 at any cell or select any cell that show you a number 1.
3) Copy it (CTRL C)
4) Special Paste --> Multiplication --> OK

Is that what you want?
I hope it helps.

I just found out how to do it: highlight the entire column then go to the following to replace - works perfectly! Thanks though. :)

dates_pic.jpg
 

easy2understandexcel

Active Member
Joined
Dec 26, 2012
Messages
299
if that worked you were probably dealing with a string of text, not an actual date/time.

Excel keeps the date as an integer and the time as a fraction, 1 per day since 1/1/1900.

For example right now is: 42,734 days since 1/1/1900, and 0.37847 (fraction of one day so far today). If you run into a real date (not string) you can convert it the way Marcilio mentioned.



<tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,122,561
Messages
5,596,849
Members
414,107
Latest member
Tigretto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top