title: Is there a way to use the formatted output from a cell, rather than the unformatted value?
body: <p>Is there a way to generically grab the text output of a numeric formatted cell? For example:</p>
  <p>(A) I have a cell formatted as Percent - the cell may well show &quot;20%&quot; while containing the value 0.2
  (B) I have another cell formatted as Currency, showing &quot;$20,000&quot; where the actual value is 20000</p>
  <p>I want to be able to extract (generically) the text result of these cells without knowing ahead of time what the format in use is in the particular cell. So imagine a function</p>
  <p>=CellText(A1)</p>
  <ul>
  <li>If I point it at (A) I would get &quot;20%&quot; as the result</li>
  <li>if I point it at (B) I would get &quot;$20,000&quot; as the result</li>
  </ul>
  <p>Is there anything already like this in Excel? Ideally I'd like to accomplish it without VBA ...</p>
  <p>Thanks, Ken</p>