Indirect formulas in cells not holding cell format after copy
 

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

Indirect formulas in cells not holding cell format after copy
 

Paste Special/ Format.
--
David Biddulph


"Cathy" wrote in message
...
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

Indirect formulas in cells not holding cell format after copy
 

On Mar 20, 4:39*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Paste Special/ Format.
--
David Biddulph

"Cathy" wrote in message

...



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- Hide quoted text -

- Show quoted text -

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

Thanks!

Cathy

Indirect formulas in cells not holding cell format after copy
 

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


"Cathy" wrote in message
...
On Mar 20, 4:39 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Paste Special/ Format.
--
David Biddulph

"Cathy" wrote in message

...



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- Hide quoted text -

- Show quoted text -

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

Thanks!

Cathy