Formula to Truncate any number of Decimals

[Legacy 167133]

Hi all you Excel Gurus,

Im am curious to know if it is at all possible to use a formula that "Drops" all the decimals so that I can have only the real true integer/s remaining.
Round does not work in this case, since I only want the number 214.54321 displayed as 214 and the number 2.94324 as 2 and work with those actual values.

Thank you!

 

[Matty]

Have a look at the =INT() function.

Matty

 

[jasonb75]

<TABLE style="WIDTH: 116pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=154><COLGROUP><COL style="WIDTH: 116pt; mso-width-source: userset; mso-width-alt: 2816" width=154><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 116pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl63 height=20 width=154>A few alternative ways

=TRUNC(A1)
</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>=ROUNDDOWN(A1,0)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>=FLOOR(A1,1)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>=INT(A1)</TD></TR></TBODY></TABLE>

 

[Legacy 167133]

Thank you Matty!

I completely forgot about that one, Pie in my Red Face!

I really feel STUPID!