You can try the following in a copy of your data:
In an empty cell, type: .5
Copy the cell
Select the cells that contain prices
Choose Edit>Paste Special
Select Multiply, click OK
ZAL wrote:
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks