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