Excel 2010 and Excel 213 copy + past value - value with many decimal digits

[gio123bg]

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

 

[gio123bg]

Hi All,
I find the possibility to have the value required if I use the TRUNC function. More exactly in my E4 cell I have the formula/link =+'Market Summary'!E47 and I see the value 59,4. If I copy and past special values on AJ5 cell I find the value 59,4169911808238.

If I set on E4 cell =TRUNC(+'Market Summary'!E47;1) and then I copy and paste special the value into the cell AJ5 I find exactly the value required 59,4.

To solve this issue I need to run a VBA macro to apply the TRUNC function on all cells but I hope to have a different solution.

Thanks in advance for your kind support.

Regards,

Giovanni