Only want two digits after decimal point.

[canadian86]

I have this in A1:

2217.153225

I want this in B1:

2217.15

I cannot format > change to currency, dollar sign, etc, because that doesn't actually remove the numbers after the cell.. it just doesn't show them. I want to remove them.

Thank you.

 

[bobinnc]

Try this in cell B1: =INT(A1*100)/100

 

[PCRIDE]

In excel there is an option in the tool bar to define the number of decimals. In Office 2010 or 2007 in the Ribbon under the Number format drop down list.

looks like this

.0
.00

 

[T. Valko]

I have this in A1:

2217.153225

I want this in B1:

2217.15

I cannot format > change to currency, dollar sign, etc, because that doesn't actually remove the numbers after the cell.. it just doesn't show them. I want to remove them.

Thank you.

Maybe this is what you had in mind:

=TRUNC(A1,2)

 

[grizz]

in excel 2000 / 2003
format cell / number / and set at 2 decimal places

 

[rjbinney]

You want to actually REMOVE the value, correct? So that 2217.153225 becomes 2217.150000?

In that case, INT(cell*100)/100 will give you what you want:

cell*100=221715.3225
INT(cell*100)=221715.0000
INT(cell*100)=221715.0000/100=2217.15

 

[canadian86]

Yes.. that worked. Thanks a lot for your help guys!!