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.