View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonie
 
Posts: n/a
Default way to get jus the number off the cells that have functions in them

Hi all,
I am wondering if anyone knows the solutions for this problem. I use
worksheet functions to get the certain values, say mean of the column.
Then the cell showing the mean value has the linked function in it.
But I want just the number (mean) instead of the links. in other
words, i want to copy the mean and paste in other workbooks without
links. Is there any way to to that?
Thank you.