title: Reference cell value as string in Excel
body: <p>In Excel, if the cell A1 has some value that gets formatted in a specific way, is there a way for cell B1 to reference the string displayed in A1?</p>
  
  <p>To clarify:</p>
  
  <ul>
  <li>If A1 displays, for instance, the time 10:31:48, I wish to have B1 reference this outputted string as shown to the user ("10:31:48", not the underlying numerical representation "0.43875").</li>
  <li>I'm well aware that there are functions for manually formatting values. However, what I'm looking for is copying an already formatted value from another cell, no matter what format that cell may have.</li>
  </ul>
  
  <p>Is something like this possible?</p>