Enron email

Algorithmic Indexing

31 May 2001, 17:12 UTC

Re: FW: Excel tip

From
Prentice Sellers psellers@haas.berkeley.edu
To
Nancy Sellers, jeff_dasovich@enron.com, Prentice Sellers, Prentice Sellers
Date
Thu, 31 May 2001 10:12:00 -0700 (PDT)
That's soooooo coooool
Quoted or forwarded from earlier messages
>---- 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.
>>
>
>