Date copy and paste

C

Cliff

When I copy and paste the start or finsh date to an excel
spread sheet, it also copies the time. I only need the
date copied and pasted not the time. It looks as follows -
-----------Fri 9/26/038:00 Any help is appreciated!!
 
T

Trevor Rabey

After you have copy/pasted to excel just select the excel cells and choose
a date format which strips the time.
 
R

Rob Schneider

Cliff said:
When I copy and paste the start or finsh date to an excel
spread sheet, it also copies the time. I only need the
date copied and pasted not the time. It looks as follows -
-----------Fri 9/26/038:00 Any help is appreciated!!

Cliff,

Date/time date in Project is just that. Holds both date and time. The
same is true in Excel. In Excel you can "format" the data to hide the
time from being displayed.
 

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

Top