Exporting Views to Excel

R

RandyK

When exporting a views created in PWA (MSPS 2003), any number greater than
1000 are being stored as text (due to the comma that MSPS brings over). For
example, my ACWP column has both $$ formats as well as text formats. I then
must convert each text cell (one at a time) to make the view correct - or
else my view is a mess and we cannot tabulate the contents!

Is there any MSPS setting I can change to make all numbers exported to Excel
stay as numbers?
 
B

Ben Howard

Hi Randy,
You can do all of this in Excel.

1. Type the number 1 into a spare cell and copy it (CTRL-C).
2. Select all your text "numbers".
3. Select Paste special, and select the Multiple operation

Hey presto, all text "numbers" are converted to real numbers (effectively
multiplied by 1) :)

Enjoy...
 
R

RandyK

Hi Ben -

I knew the work around in Excel - I was just thinking that perhaps there was
something in MSPS that could be done so that we could export views and send
them out without clean up effort. What happens when you do the work around
in excel is that, although the text converts to numbers, you lose the
formatting of that range of cells (which can be fixed). I was just thinking
that Microsoft would have some way of exporting numbers as, just that,
numbers....

Guess not, eh?

Thanks for the post...
 
Top