Exporting to Excel without labels

S

Scott McClure

I don't see this topic in the last 7 or 8 pages so. I
have not been able to find a way to export the data
(short of going through SQL directly) to Excel so that
the Duration, Work, and other numeric fields are actually
numbers in the target spreadsheet. Is there a way to do
this? We would, of course, like to do some analysis and
manipulation but with the h or d label we have to go
through every cell and remove it. Might as well type it
in from scratch!

Thanks,
Scott
 
J

Jack D.

Scott said:
I don't see this topic in the last 7 or 8 pages so. I
have not been able to find a way to export the data
(short of going through SQL directly) to Excel so that
the Duration, Work, and other numeric fields are actually
numbers in the target spreadsheet. Is there a way to do
this? We would, of course, like to do some analysis and
manipulation but with the h or d label we have to go
through every cell and remove it. Might as well type it
in from scratch!

Thanks,
Scott
Click to expand...

There is a very simple way.
Export to excel
Select the column with the offending data.
From the edit menu select find and replace
enter d in the find box and leave the replace with box empty. Click Replace
All..
Do the same thing for h.


--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++
 
J

Jack D.

You are welcome. With the complications of many of these software products
it can be easy to overlook the simple things.

-Jack
 
Top