Enron email

Algorithmic Indexing

31 May 2001, 13:04 UTC

FW: Excel tip

From
Nancy Sellers nancy.sellers@robertmondavi.com
To
jeff_dasovich@enron.com, Prentice Sellers, Prentice Sellers
Date
Thu, 31 May 2001 06:04:00 -0700 (PDT)

The sender added no text of their own; everything below is quoted or forwarded.

Quoted or forwarded from earlier messages
>  -----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.
>