Z
zann
I'm looking for a way to format a cell to automatically
round down to the hundredths. (I don't mean a function
like ROUNDDOWN.)
My example is I want cells containing currency values
(doesn't have to be the "currency" format--may be any
format with two decimal places) to always be rounded down
to the penny instead of the nearest cent.
Any suggestions would be greatly appreciated![Smile :) :)](/styles/default/custom/smilies/smile.gif)
round down to the hundredths. (I don't mean a function
like ROUNDDOWN.)
My example is I want cells containing currency values
(doesn't have to be the "currency" format--may be any
format with two decimal places) to always be rounded down
to the penny instead of the nearest cent.
Any suggestions would be greatly appreciated
![Smile :) :)](/styles/default/custom/smilies/smile.gif)