excel in a small number of papers setting a small problem?

For example:I wrote a column B in a data 356.89, now I want to remove the last, but do not want to rounding, asked for 356.8 this data, how do ah?

boss, this is no way to drop, only nine to delete it, the coin can not have both! ROUNDDOWN

Senate can see the

close to zero, down (the direction of reducing absolute) number of rounding.

grammar

ROUNDDOWN (number, num_digits)

Number needed for the down Rounding of any real number.

Num_digits after rounding the number of digits.

That

function ROUNDDOWN and function ROUND function similar to the difference between the function is always ROUNDDOWN Rounding down figures.
If num_digits greater than 0, then rounding down to a specific decimal places.
If num_digits equal to 0, then rounding down to the nearest whole number.
If num_digits Less than 0, then carried down the left side of the decimal point in the round.
Example

example, if you will be copied to a blank worksheet, may be easier to understand the example.

Methods of operation to create a blank workbook or worksheet.
In the “help” in the subject sample selection.Do not select the row or column heading.

Help from the selected sample .

press Ctrl + C.
in the worksheet, select cell A1, then Ctrl + V.
To view the results and view the results of the formula to return to switch between Press Ctrl + `(accent), or the” Tools “menu, point to” review the formula, “and then click” formula review mode “.

1
2
3
4
5
6
AB
formula that (the results)
= ROUNDDOWN (3.2, 0) will be rounded down to 3.2, decimal places for 0 (3)
= ROUNDDOWN (76.9,0) will be rounded down to 76.9, the decimal places for 0 (76)
= ROUNDDOWN (3.14159, 3) rounding down to 3.14159, to retain the three decimal (3.141)
= ROUNDDOWN (– 3.14159, 1) -3.14159 rounding down, to retain a small number (-3.1)
= ROUNDDOWN (31415.92654, -2) will 31415.92654 rounding down to the left of the decimal point two (31,400) elect a ( If the column C), in cell C1 enter the following
= INT (A1 * 10) / 10
and then copy down the cell C1 can be completed by inserting a new C, if B1 = 356.89
C1 enter the formula:= TRUNC (B1, 1) that is equal to 356.8.

TRUNC:the cut-off figure for the whole or retain a small number of designated median.ROUNDDOWN can function in the cell

Enter the formula:= ROUNDDOWN (356.89,1) can be had!

Wish you success! Chengshmily positive solutions, TRUNC function