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