i just want to display a whole number coming from other cell to another..
F Fred Smith Sep 22, 2007 #2 You probably want to format the cell. Right click on the cell and choose Format Cells...
G Gord Dibben Sep 22, 2007 #3 Maybe Format>Cells>Number to 0 decimal places? Or maybe =INT(A1) Gord Dibben MS Excel MVP
