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