
Not applicable
2016-03-30
03:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to show number in one decimal place without rounding
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
2,551 Views
5 Replies

MVP
2016-03-30
07:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this:
Left(0.080253153584897, 3)


Partner - Champion III
2016-03-30
07:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use Floor() to round the number down.
=Floor(0.080253153584897, 0.1)
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2,320 Views

MVP
2016-03-30
07:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
2,320 Views

MVP
2016-03-30
07:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 |
2,320 Views

Master II
2016-03-30
07:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can u try this,
2,320 Views
