Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Concatenate numbers and text while holding a custom number format. | Excel Worksheet Functions | |||
copying and holding certain cells in the function | Excel Discussion (Misc queries) | |||
copying and holding certain cells in the function | Excel Discussion (Misc queries) | |||
Copy the value of a cell, no format, into several cells. | Excel Discussion (Misc queries) | |||
Cells not holding format | Excel Discussion (Misc queries) |