ExcelBanter - I HAVE A SHEET WITH PRICES AND I NEED TO MAKE HALF

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I HAVE A SHEET WITH PRICES AND I NEED TO MAKE HALF (https://www.excelbanter.com/excel-discussion-misc-queries/31120-i-have-sheet-prices-i-need-make-half.html)

ZAL

I HAVE A SHEET WITH PRICES AND I NEED TO MAKE HALF

Debra Dalgleish

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 EditPaste Special
Select Multiply, click OK

ZAL wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 06:12 PM.