Remove Time from Start/Finish Date Columns When Exporting to Excel

[Colleen]

One of my managers says that when I send her the MSProject file and she
converts it to Excel that in addition to the start/finish dates, it puts in a
time in that field as well. For our project we are not dealing with time at
all, so all we need to know is the dates. She's been manually removing this
time from the field each week, but we are wondering if there is a way to
remove this time option so only dates appear in those columns? I look in the
project plan options and found an area to specify the working times, but when
I tried to delete both fields it would not allow me. It seems that a time
needs to be in both fields. Please confirm if there is a way to remove this
time stamp from the start/end date columns. Thanks!

Colleen

 

[JulieS]

Hello Colleen,

Sorry, no. Even if you change the display (Tools > Options, View
tab) to only show date and not time, the time data will be
exported to project. Even though *you* are not dealing with
time, MS Project is.

The best I can suggest is just to change the cell formats once
the data is in Excel.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Jim Aksel]

Hello Colleen,
It is probably easiest to do this in Excel. Highlight the entire row or
column.
Right click and select "Format Cells"
Select a date format without hh:mm.

--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com