You can never get Excel to round numbers by using formatting, the display
rounds up or down depending on the number, however the underlying value is
still the same. You can only get this upon entry by using an event macro


--
Regards,

Peo Sjoblom



wrote in message
ups.com...
I'm trying to format a cell to round numbers DOWN as I type them.
Right now, Excel seems to only round numbers UP. Is there any way to
do this without using the ROUNDDOWN formula? I know I can use the
ROUNDDOWN formula, but that only works if he formula is in a different
cell from the data. Thanks.