How to remove letter "h" when exporting to excel

C

Caroline

Hi all,
when exporting project centre grids to excel it is very annoying that
any work columns are text such as "67h" when what you want is the
number "67", what is the easiest solution to this?
I'm just trying to average up the number of actual hours spent in
various projects which could be done quickly with an export to excel
except for this issue, I don't reallly want to write any macros right
now - is there a faster solution?

Thanks

Caroline
 
M

Marc Soester [MVP]

Hi Caroline,

a little macro would be my suggestion :) I think that is the fastest way.
You cannot set anything in Project Server, so the only way I think is to
eihter manually change them after the export, or create a little macro
hope this helps
 
M

Marc Soester [MVP]

Hi Caroline,

not sure if my first post came through, got an error message so here it is
again:
I would recommend creating a little macro. Project Server gives you no
options to change this, so you can only changes it after the export. That
means you can either do this manually or create a little macro.
Hope this helps
 
M

Marc Soester [MVP]

Hi Caroline,

not sure if my first post came through, got an error message so here it is
again:
I would recommend creating a little macro. Project Server gives you no
options to change this, so you can only changes it after the export. That
means you can either do this manually or create a little macro.
Hope this helps
 
M

Marc Soester [MVP]

Hi Caroline,

not sure if my first post came through, got an error message so here it is
again:
I would recommend creating a little macro. Project Server gives you no
options to change this, so you can only changes it after the export. That
means you can either do this manually or create a little macro.
Hope this helps
 
R

Rod Gill

I usually select all cells then press Ctrl+H for replace. Search for he and
replace with an empty cell. This deletes all he and converts the string to
numbers.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 

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

Similar Threads

VBA - exporting serial letters to single documents 0
Please Help!! How do I export a Cashflow from MS Project to Excel? 0
Removing "H" from "Work" fields 5
Export to Excel as text not numeric 10
Export Grid to Excel 8
Using Portfolio Server 2007 project export with Project Pro 2007enterprise template 0
Exporting to Excel from Data Analysis 4
Frequent crashes of IE when using Active X Control Project Centre 4

Top