Converting Formula to it's value

  • Thread starter Thread starter David Nizen
  • Start date Start date
D

David Nizen

I'm trying to convert the result of a formula into plain
text. I know I can copy the cell and then use Paste
Special, Values, but I'd like to have a separate
worksheet in the same workbook, that displays the values
automatically. Any ideas?
 
Assuming your formula is on Sheet1 in cell A3, type the
following in your separate worksheet:

=Text(Sheet1!A3,"#")

you can put whatever formatting you want in place of the
#, such as mm/dd/yyyy. Be sure it's in quotes.
 
Have you tried writing a macro to copy the results and
paste as value in another sheet? That's the only other
option I can think of. Lemme know if you want help with
that.
 
Back
Top