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?
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.
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: