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
 

--------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Project for Windows, versions 3.0, 3.0a, 4.0
--------------------------------------------------------------------
 
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.
