View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] lkirkland@whitecase.com is offline
external usenet poster
 
Posts: 1
Default Rounding down numbers in cell

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.