Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate numbers and text while holding a custom number format. jpowell111 Excel Worksheet Functions 9 February 10th 10 11:22 PM
copying and holding certain cells in the function rwong520 Excel Discussion (Misc queries) 1 July 28th 06 06:47 PM
copying and holding certain cells in the function rwong520 Excel Discussion (Misc queries) 1 July 28th 06 06:20 PM
Copy the value of a cell, no format, into several cells. Harvey Eastman Excel Discussion (Misc queries) 3 June 30th 06 03:46 AM
Cells not holding format Aurora Excel Discussion (Misc queries) 0 March 9th 05 07:11 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"