On 31/12/2012 09:36, Paul Crabtree wrote:
Thanks for all the replies !!!
Appeared to have sparked a little interest in the subject
best wishes for the new year
Paul C
You would have to create a UDF to allow you access to the VBA macro
implementation or roll your own very clumsy implementation via a string
intermediate stage. More details about Excel rounding online at:
http://support.microsoft.com/kb/196652
It still isn't pretty since you will have to add and subtract 1 in the
LSB to get weathermens rounding as opposed to bankers rounding.
--
Regards,
Martin Brown