Thread: text as 0
View Single Post
  #1   Report Post  
Rick Stanford
 
Posts: n/a
Default 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