Thread: How to convert function return value to text?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
merri merri is offline
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?
Reply With QuoteReply With Quote