Converting Formula to it's value

[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?

 

[Beth]

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.

 

[Beth]

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.