Removing "H" from "Work" fields

[jamos]

I am trying to export my resource assignments grid to Excel so that I can do
various things with the information, but I really need the fields with
"work", "actual work", etc. to kill the "h" on export so that I can have
formulas work in Excel.

Does anyone know of any way to do that? Or just customize my PWA resource
assignments view so that I don't have to have the "h" in there to begin with?

Thanks!

 

[rt]

I just do a search and replace in Excel. (replace h with nothing).
It's a nuisance but simple enough. I'd be interested to hear better
methods.

 

[JulieS]

Hi Jamos and RT,

You may also like to use the Data > Text to Columns command in Excel.
The wizard walks you through and fairly quickly separates at the space
between the number and text.

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

 

[rt]

Hi Julie, never knew this was there I've seen something similar in
Access but it appears you need to do quite a few clicks to get it
right (or I'm doing it wrong). Anyways, thanks for the tip, learned
something new today!

 

[rt]

Hi Julie, never knew this was there I've seen something similar in
Access but it appears you need to do quite a few clicks to get it
right (or I'm doing it wrong). Anyways, thanks for the tip, learned
something new today!

 

[JulieS]

You're welcome rt and thanks for the feedback.
Julie