i'm trying to update a "text box" with a value from a cell on another
worksheet. i've figured out how to do this simiply by entering the
appropriate cell in the 'LinkedCell' area in the properties box. however,
the linked value comes in as text, when it is actually a number, formatted
with a comma and a dollar sign. Is there some obvious thing I am missing,
like instead of a text box, use a "number box"?