|
|
Enron Mail |
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. << < <
|