Cell Ammendments

  • Thread starter Thread starter sbremner
  • Start date Start date
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
 
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
 
Back
Top