Remove the 12d (d) from the display on resource usage

[MartinCroft]

Hi

I need to copy and paste details from the resource usage sheet into excel, but dont want to take the d sysmbol. I.e it shows as 12d but want it to show only 12, using project 2003

Can this be done and how

Cheers

 

[PDQBach]

I have to do this all the time.

The easy way: after you paste the information into Excel, the range of cells which received the pasted information is automatically already selected. Press Ctrl+H (opens the Change dialog) and change " d" to nothing and then click on the Change All button. This takes all of 5 seconds if you're a slow typist.

If you want to do this using VBA then you'll have to write a macro that works with TimeScaleData (kinda finicky the first few times you try working with it) and, of course, you'll also have to get Project to load Excel or vice versa. I posted some code in a recent thread showing how to get Excel to load Project (or was it the other way 'round -- can't remember now). This will take considerably longer than 5 seconds.

 

[PDQBach]

It occurred to me that I was thinking of the Task Usage and Resource Usage displays where I do two copy&paste operations: one for the left grid side and one for the right spreadsheet side -- my reference in my earlier answer was for the actions you'd perform after pasting in the right spreadsheet side into Excel.

If, however, you were using the left grid side from something like View | Gantt then, after pasting, you will need to select the spreadsheet column which received the Duration or Work columns and then do the search-and-replace.

It also occurred to me afterwards that you may have cleared the checkbox on Tools | Options | Edit-tab "Add space before label" and, in this case (depending on which view you used as the source for the data when you did your copy) you may want to search on " d" or "d" -- whichever is appropriate.