Microsoft KB Archive/121146

Resource Usage Cost Pasted as Text Into Quattro Pro v5.0

PSS ID Number: Q121146 Article last modified on 08-24-1995

4.00

WINDOWS

= SYMPTOMS =

When Resource Usage data, formatted as Cost, is pasted into Quattro Pro v5.0, it is interpreted as text data, not numbers. You will not be able to add these values until they are converted into number format.

= WORKAROUND =

To work around this problem, follow the appropriate procedure for your version of Microsoft Project.

For Project 4.0

 * 1) Select the international settings in the Windows Control Panel.
 * 2) Change the number format so that there is no thousands separator.
 * 3) In Project, choose Options from the Tools menu, and select the View tab.
 * 4) Use a blank as the currency symbol.

For Project 3.x

 * 1) From the Options, menu choose Preferences.
 * 2) Change currency symbol to a blank.
 * 3) Change the thousands separator to a blank, and choose OK.

= MORE INFORMATION =

The products included here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products’ performance or reliability.

All versions of Microsoft Excel and Lotus 1-2-3 v4.0 interpret the normal currency format correctly when Resource Usage is pasted.

KBCategory: kb3rdparty KBSubcategory:

= Additional reference words: 4.00 Gantt framed start end shape =

Copyright Microsoft Corporation 1995.