Deleting info in a column

  • Thread starter Thread starter JPD
  • Start date Start date
J

JPD

I am exporting info from MS Project and my dates come out formatted as
such: 2/5/2007 8:00


I do not need to see the time, and i know there is a function (or
something) that will run through the column and delete the time to
just show 2/5/2007 ...... I can not remember how to do this.

any help appreciated!
 
If you just want to change the way the info is displayed, one way would
be to format the column as a date.
 
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

Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
How to enter start and end date/time in excel based on some specific value. 7
Stupid Excel Tricks 1
Unique #s in column, need multiple associated numbers in columns 5
Show other cell if blank 5
Counting Hours in Multiple Days 7
Can't Explain N/A in Vlookup 2
Two Totals from the same column 2

Back
Top