View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Peterson - Velox Consulting, LLC Paul Peterson - Velox Consulting, LLC is offline
external usenet poster
 
Posts: 21
Default Exporting MS Project Values into Excel

I am exporting the "Actual Work" values from MS Project into an excel
worksheet. Unfortunately, 40 hours is stored as "40h" in excel which makes
it impossible to use for calculations. I would like some automatic way of
making sure this value is always 40 (rather than 40h) - I don't want to
manually manipulate my excel file. Any ideas?

Thanks.

Paul C. Peterson.