Hi Paul,
A simple experiment will show you that 1.575 rounds to 1.58 while 1.585
round to 1.59 with formatting and with the ROUND function. Clearly Excel
does not use the ASTM E29 protocol (aka Banker's Rounding)
However, VBA does follow ASTM E29
(see
http://support.microsoft.com/default...;EN-GB;q194983 and
http://support.microsoft.com/default...b;EN-US;196652)
So the user-defined function below will round both 1.575 and 1.585 to 1.58
Function myround(rng, fig) myround = Round(rng, fig)End Functionbest wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
wrote in message
...
Does anyone know if the format function ("Format/Number with x number of
decimal places) happens to conform with ASTM E29 for the last right-hand
digit...???
Thanks
Paul