View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jmorris305
 
Posts: n/a
Default Convert displayed number to absolute value


I need to convert a division answer to 2 decimal places and convert the
displayed value to an absolute value. For instance if the result of a
division is .93169. I then need to convert the displayed value (.93)
to an absolute value so that I can then multiply another number by the
absolute value (.93) instead of the actual value (.93169).

My question is how do I convert the division answer to an absolute
valeu?


--
jmorris305
------------------------------------------------------------------------
jmorris305's Profile: http://www.excelforum.com/member.php...o&userid=31977
View this thread: http://www.excelforum.com/showthread...hreadid=517075