LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How to convert function return value to text?

For example I have a column of functions C, like
=A1-B1
=A2-B2

And so on. In C column I see results of calculation. But that's still
a function and if I change A and B the C will change.

How can I transform results of calculation to simple text? And see
only resulting numbers in C column?
 
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
Need function to return text value sahafi Excel Worksheet Functions 4 March 18th 07 03:31 AM
Using TODAY function to return a date as text GH Excel Discussion (Misc queries) 1 December 19th 06 06:17 PM
Need Function to look up value and return a text value? Accestimator Excel Worksheet Functions 2 August 28th 06 01:36 PM
What function do I use to return a certain value for specific text marjoryann Excel Discussion (Misc queries) 4 June 30th 06 12:00 AM
How do I convert text to columns when there is a carriage return? Stumped Excel Worksheet Functions 1 March 11th 05 05:20 PM


All times are GMT +1. The time now is 11:28 AM.

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"