Hello. I have a bunch of indirect forumlas in cells that are taking
values from another open workbook. I use the copy and pastespecial
method to get the values of the formulas but it's not taking the
format (number with no decimal places). It pastes the whole number
ie: 9878.988776 instead of 9879. I have tried the pastespecial values
and number format option but it still doesn't work. I hope someone
can help!!!

Thanks,
Cathy