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 How do I convert the result of a formula in a field into a value

How Does one convert the result of a formula to a value -
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default How do I convert the result of a formula in a field into a value

Hi,

Copy the result then

Edit|Paste special
select values and OK

Mike

"Hicks" wrote:

How Does one convert the result of a formula to a value -

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 364
Default How do I convert the result of a formula in a field into a value

"Hicks" wrote in message
...
How Does one convert the result of a formula to a value -


The result of a formula IS a value! Please explain what you mean.


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
Pivot table formula (calculated field) result is incorrect Paul Excel Worksheet Functions 1 July 30th 07 05:26 PM
How do I convert formula result into numbers so I can sum results? Barsha Excel Discussion (Misc queries) 1 November 11th 06 07:18 PM
How can I convert the result of a formula to a whole number? crystal Excel Discussion (Misc queries) 1 April 28th 06 07:06 AM
Convert Formula Result Christina Excel Worksheet Functions 2 October 12th 05 10:30 PM
I've put a formula in a field, the result won't show kanye Excel Discussion (Misc queries) 5 July 7th 05 08:07 PM


All times are GMT +1. The time now is 06:47 PM.

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

About Us

"It's about Microsoft Excel"