31 May 2001, 17:12 UTC
Re: FW: Excel tip
- From
- Prentice Sellers psellers@haas.berkeley.edu
- 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. >> > >