How to show number in one decimal place without rounding

[#1]

I wanted to show this number 0.080253153584897 in one decimal place as 0.0

How do I do?

I tried this,=num(0.080253153584897,'#,##0.0') but the result is giving me 0.1, its getting rounded off.

I wanted to show this as 0.0

Please help me out friends.

Thanks,

SHAMLY P T

[sunny_talwar]

May be this:

Left(0.080253153584897, 3)

[jonathandienst]

Use Floor() to round the number down.

=Floor(0.080253153584897, 0.1)

[tresesco]

Floor(Yournumber, 0.1)

In fact, having 0.1 as base, number would not get rounded down but will remain same till 1 decimal point, and that's because 1*Z=Z.

[Kushal_Chawda]

Use Floor() function

Syntax:

Floor(x[, step[, offset]])

Return data type: numeric

Examples and results:

Examples	Results
Floor( 2,4 )	Returns 0
Floor( 4,2 )	Returns 4
Floor( 3.88 , 0.1 )	Returns 3.8
Floor( 3.88 , 5 )	Returns 0
Floor( 1.1 , 1 )	Returns 1
Floor( 1.1 , 1 , 0.5 )	Returns 0.5

[buzzy996]

can u try this,