rounding

  • Thread starter Thread starter minimus
  • Start date Start date
You can't select 1 decimal places and not having the displayed number
rounded.
If you don't want it to be displayed like that you would need to format as
general but
then all decimals will show. You can use a help column and a formula like

=TRUNC(A1,1)

and 1.29 will be displayed as 1.2


--


Regards,


Peo Sjoblom
 
when chosen


excel rounds the number.
Click to expand...

It's not actually rounding the number, only the display of that number.

What do you want to happen?
How can I order excel not to round but just show the real decimal?
Click to expand...

Again, Excel is only rounding the display, not the number.

What do you mean by "real decimal".

You could format the cell as General.
--ron
 
Because usually 1.2 is a more accurate representation of 1.19 than 1.1 is,
and you choose to do so when demanding 1 decimal only. Majority is always
right, right ?

Best wishes Harald
 
Back
Top