Amount, hmm..., numbers?
FormatCellsNumbersDecimal places maybe
perhaps you typed in 0.899756 and are getting 1 because you have 0 or too
few decimal places formatted....????

"EdMac" wrote:


If you tell us what you type and what you get it would help

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=504934