example: 12.954; dynamically DELETE number after 'point'????

[nescartel]

let's say i have 12.954, how to delete numbers after decimal point so that i got 12 as the output? if i just format the cell to have integer values, it will automatically round the number to 13, which i don't want! any solutions?

 

[Seti]

Is this the result of a formula? If so, try ROUNDDOWN(A1,0) or TRUNC(A1,0) or INT(A1).

 

[Legacy 51064]

You could also format the cells to round to the nearest whole number

 

[nescartel]

WOW!!! THANX SETI!!! i've been searching the net for this solution, and i got it now!

 

[nescartel]

Okay, how come when i apply ROUNDDOWN on 1.00 it appears to be 0?! supposed to be 1 right? can anyone help me here?

 

[Peter_SSs]

Okay, how come when i apply ROUNDDOWN on 1.00 it appears to be 0?! supposed to be 1 right? can anyone help me here?

The 1 may not actually be 1. Is it a number entered directly? Or the result of a formula? Try selecting the cell with 1 and format it to show more decimal places, you will most likely find that it is actually 0.96754 or something similar.

 

[nescartel]

YUP! that does it!!! turns out the number is actually 0.9++ something. solved the problem by adding "+0.01" at the back of the roundup. THANX AGAIN!!! :wink: