Indirect formulas in cells not holding cell format after copy

  • Thread starter Thread starter Cathy
  • Start date Start date
C

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
 
Paste Special/ Format.
--
David Biddulph







- Show quoted text -
Click to expand...

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

Thanks!

Cathy
 
Back
Top