Indirect formulas in cells not holding cell format after copy

[Cathy]

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

 

[David Biddulph]

Paste Special/ Format.

 

[Cathy]

Paste Special/ Format.
--
David Biddulph







- Show quoted text -

Thanks David...can you explain a little more? I'm looking for the
code that will do this?

Thanks!

Cathy

 

[David Biddulph]

You used Paste Special/ Values to get the number.
Use Paste Special/ Format to get the format.