| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to truncate to tenths digits without rounding
I need the result of a formula to be calculated and displauyed to the tenths
digit, but I do not want to Round it, I simply want to drop the digits after the tenths. If I change the display formatting of the cell, it will use the underlying number in other calculations, but I only want it to use to the tenths without it being rounded. How do I do that? Thanks, Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to truncate to tenths digits without rounding
=ROUNDDOWN(A1,1)
-- Gary''s Student - gsnu200737 "Steve Haack" wrote: I need the result of a formula to be calculated and displauyed to the tenths digit, but I do not want to Round it, I simply want to drop the digits after the tenths. If I change the display formatting of the cell, it will use the underlying number in other calculations, but I only want it to use to the tenths without it being rounded. How do I do that? Thanks, Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to truncate to tenths digits without rounding
You can also use the "trunc" function to do that that more explicitly - see
help for that function to try it out. "Steve Haack" wrote: I need the result of a formula to be calculated and displauyed to the tenths digit, but I do not want to Round it, I simply want to drop the digits after the tenths. If I change the display formatting of the cell, it will use the underlying number in other calculations, but I only want it to use to the tenths without it being rounded. How do I do that? Thanks, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel, how enter 15 digits in a cell without rounding off last? | Excel Worksheet Functions | |||
| calculating time with tenths | Excel Discussion (Misc queries) | |||
| Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
| Format monetary amount to 9 digits with No decimals without rounding | Excel Worksheet Functions | |||
| truncate ssn to first four digits | Excel Discussion (Misc queries) | |||
Hybrid Mode
