|
| 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
March 20th, 2010, 01:26 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
March 20th, 2010, 06:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
March 20th, 2010, 07:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
March 21st, 2010, 05:39 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
