Spreadsheet formulas

lukesdyer · May 16, 2012, 5:11pm

Is there a way to:

use a formula to move the decimal point from a cell that is generating data based on a DIV formula?

ex: I want 0.333333333 to appear as 3.333333333

use a formula to limit length of number within a cell?

ex: I want 3.333333333 to just appear as 3

radyno · May 17, 2012, 5:01pm

Hi,
there is no way to take fractional part or round result of formula calculating. I think functions ROUND/FLOOR/CEIL/FRACT will be added in the next release.