View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Manoj Manoj is offline
external usenet poster
 
Posts: 28
Default divide all numbers in range by a fixed number

Take an empty cell... Type in "0.88"... copy... highlight all the cells that
has to be divided by this number... right click...paste special... select the
divide check box... ok

See if this works... This can be used for all operators... i.e.,
add/subtract/multiply or divide.

manoj


"dhig3903" wrote:


I want to be able to type numbers into fields and have Excel
automatically divide that number by .88 in order to obtain a selling
price for our inventory.

I think I am making this a lot harder than it really is.

Any help would be greatly appreciated!!


--
dhig3903
------------------------------------------------------------------------
dhig3903's Profile: http://www.excelforum.com/member.php...o&userid=37242
View this thread: http://www.excelforum.com/showthread...hreadid=569577