Cut / Paste excel data without decimal values

**cooper1308** · 07-12-2009, 07:39 AM

Hi all,

Probably a simple question but doing my head in trying to fix...

The data comes from the divison of two stock prices that are updating in realtime..... hence i will get a figure of lets say 2.5563. I have it set so that the cell auto rounds to the nearest number even though the formula bar displays the above figure...

My problem arises when I cut and paste this data into a new cell, the decimal figures are still there. I have to have this figure pasted as 3...... not 2.5563 and rounded up to 3...

Anyone know how to fix..?

Thanks!

**oldchippy** · 07-12-2009, 10:43 AM

Hi,

Welcome to the forum, if your data is in A1 you can round with this in B1

=ROUND(A1,0) then copy and paste that?

**gurusanthanam** · 07-12-2009, 11:13 AM

Hi,

Format the Cell B1 to "No Decimal" in Format Cells, Number Option.

Copy from the source and use Paste Special-Values.

By this, Number in the cell will be displayed as "3"...and in the formula cell you can find "2.5666"...

Hope this helps you.

Regards,
guru