text as 0
I have cells formatted as 'text' in several worksheets linked to a text cell
on a 'master' worksheet. When I enter text in the cell on the master
worksheet, it is copied into the cells on the linked worksheets. However,
when I delete the text in the cell on the master worksheet, I get a '0' in
the cells on the linked worksheets - rather than a blank.
How can I format the cells in the linked worksheets to just show a blank,
rather than a '0'?
Thanks,
Rick
|