If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|