linked cell enters the value exactly as it's displayed. hint, choose another
cell on the same worksheet that has the value that changes then enter this
formula
=(here enter the address for the dollar value cell)
make sure the format for that cell is general NOT currency
then use that cell as the linked cell instead of the currency one

"DirInfo" wrote:

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