Dates in Excel

[jalenben1]

I have a date in a cell that says 10/31/2010 16:38 PM from a database. How to format the date so that it will only have the date and not the extra stuff.

 

[SkipVought]

Select the date cell(s) and FORMAT as desired via Format > Cells > Date

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[combo]

If you need only visual formatting, format the cell as pure date.
To remove fractional part of date/time, select cells you want to change. In find/replace dialog: set " *" to find (no quotes), nothing to replace.

combo

 

[kjv1611]

combo,

Can you tell anything about why that find/replace method works. I guess what I'm asking is, what are you finding with looking for the asterisk? Thanks for any info there.

 

[SkipVought]

SPACE ASTERISK since Date Time TEXT is... well er uh DateValue SPACE TimeValue


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kjv1611]

Okay, so the Asterisk can be used as a wild card in find/replace? That's something I did not know for sure. I always thought the find/replace tool was strictly a 100% text tool... meaning it wouldn't' recognize any sort of wild cards.