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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates in Excel 2003 1
How to customize =Now() 11
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
arrived in appt time 1
date 1
When subtracting dates issue 11
Date Formats 1
modifying time categories 2

Back
Top