That's soooooo coooool
>---- Original Message ---
>From: Nancy Sellers <Nancy.Sellers@RobertMondavi.com>
>To: "'Jeff Dasovich'" <Jeff_Dasovich@enron.com>,     "Prentice @ 
Berkeley"    <PSellers@haas.berkeley.edu>,     Prentice Sellers 
<PSellers@pacbell.net>
>Cc:
>Subject: FW: Excel tip
>
>>  -----Original Message-----
>> From:  Lisa Castle
>> Sent: Thursday, May 31, 2001 1:02 PM
>> To: Nancy Sellers
>> Subject: Excel tip
>>
>> My turn to return the favor of the tip you sent to me (let me know if
>> you've already heard of this one).
>>
>> Here is a tip to change a table of data from whole numbers to $000's.
>> In an empty cell, type 1000.
>> Select the cell, and click Copy on the Edit menu.
>> Now select the cells containing the values you want to change.
>> On the Edit menu, click Paste Special.
>> Under Paste, click Values and under Operation, click Divide.
>> Click OK.
>> This will work to multiply, divide, etc.  If you use -1 and multiply, it
>> will change values to negative.
>>
>
>