31 May 2001, 13:04 UTC
FW: Excel tip
- From
- Nancy Sellers nancy.sellers@robertmondavi.com
- 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. >