Roundind Down

[Jeff]

Is there a way that for all of my cells in the
spreadsheet I can round down. For example, if a cell
says 1.7, I really only want it to say 1. Any help would
be greatly appreciated.

Thanks,
Jeff

 

[Frank Kabel]

Hi
in a helper cell use
=ROUNDDOWN(A1,0)
or
=TRUNC(A1)

Also see:
http://www.xldynamic.com/source/xld.Rounding.html