How to Copy and paste values only and make excel round numbers 1

[RamziSaab]

I need to copy and paste a large amount of data as values only...but i also need excel to round the numbers to zero decimal places!!

any help would be appreciated

Cheers

 

[DaleWatson123321]

Ramzi,

1) Enter the formula =ROUND(xxx,0) - where xxx refers to the cell to be rounded.

2) Copy the formula for each cell containing data.

3) Highlight the formulas, and use: Copy, and then Edit - Paste Special - Values.

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[RamziSaab]

Dale,

Thanks, exactly what i needed i can acutally put
=round((formula i want),0).

Thanks