View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nmeyer Nmeyer is offline
external usenet poster
 
Posts: 3
Default remove time stamp from date in excel

I have pasted data from project into excel. I have the project dates with a
time stamp 07/14/07 10:12 PM. I want to strip the time portion off from the
date. Format just changes the appearance but does not remove the hidden time
stamp.