Solved: rounded down format/display

[stanl]

Given a colum of numbers display w/6 decimal places, I need these either displayed on a summary sheet in the same workbook as 3 decimal places, or exported to Access, rounded down - i.e. 0.052727 appears as 0.052. I have looked at floor() and trunc() and some exotic formulas but was hoping for something like 'Set Round Off':rotlaugh: Stan

[Bob Phillips]

Just format the summary sheet to 3 dec places Stan. There is no setting to tell Excel to display numbers to a set number of places, it is all done via formats.

[stanl]

Just format the summary sheet to 3 dec places Stan. There is no setting to tell Excel to display numbers to a set number of places, it is all done via formats.

Did that.... but 0.052727 rounds up to 0.053, I want 0.052.

Oops..never mind... just saw the rounddown() function...

[mdmackillop]

If you want to change the value to the rounded down figure
=INT(A1*1000)/1000

[stanl]

If you want to change the value to the rounded down figure
=INT(A1*1000)/1000

man, you are reading my mind... just finished the access export code using something similar. :friends: Stan