PasteSpecial Format to two decmo only

[bgonen]

I'm trying to format the numbers that get copied/pasted to two decmo-places only

For example I want to get $1,272.69 but instead, I get 1272.69345238095

Please Login or Register  to view this content.

[JBeaucaire]

Maybe something like this instead:

Please Login or Register  to view this content.

[bgonen]

Thanks for the effort. For some reason the values won't get pasted over. In other words, I get a blank column.

[StuCram]

Maybe format the cell for 2 decimal places:

Please Login or Register  to view this content.

PS - Do this before pasting any value into it.

[bgonen]

Thank you both, I added each of your codes as additional line and it works.

Despite the two decmo places and rounding , when I try to edit or use F2 I still see numbers as the following 1272.69345238095

Not a big deal but irritating.

[StuCram]

You may also want to set to check off this Excel preference: Calculation ----> Set Precision As Displayed.

[Debraj Roy]

try JB's suggestion..

Please Login or Register  to view this content.

*** adjust ranges as required..