Hi All,
I have a problem when I try to copy a value for example (279,1) that I find in a cell and corresponding to a formula as result. After a copy, the value in a new cell is 279.112917289668. If I try to set the cell format to numeric value with 1 decimal place, I see 279,1 but the number is not truncate to 279,1. I need to have the number showed into the cell because I have problems in using this number in a new sum.
Any help will be well appreciated.
Thanks in advance.
Regards,
Giovanni
I have a problem when I try to copy a value for example (279,1) that I find in a cell and corresponding to a formula as result. After a copy, the value in a new cell is 279.112917289668. If I try to set the cell format to numeric value with 1 decimal place, I see 279,1 but the number is not truncate to 279,1. I need to have the number showed into the cell because I have problems in using this number in a new sum.
Any help will be well appreciated.
Thanks in advance.
Regards,
Giovanni