Revise cells to just show date & not time

[MrWonderfull]

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?

 

[Marcílio_Lobão]

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]

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.

 

[easy2understandexcel]

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>