Cell Ammendments

S

sbremner

Hi,
Probably really simple.
I have a list of approx 5000+ dates and times that I need to do some
trend analysis on.
However, thr format is:

"dd/mm/yyyy hh:mm"

I want to be able to basically keep the "dd/mm/yyyy " content and scrap
the time.
i can edit the format, but it is only asthetic and doesn't acctually
alter the data.

Can anyone help?

Thanks

Steve
 
C

Chip Pearson

Use the TRUNC function in another column to remove the time portion. E.g,

=TRUNC(A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top