View Single Post
  #1   Report Post  
Neil
 
Posts: n/a
Default Reference cells from another worksheet problem

Worksheet call MAIN
Worksheet call OTHER

In a cell on the OTHER worksheet I have =MAIN!A1. The value in A1 in the
MAIN worksheet is space, but it appears as 0.0.0000 in the cell on OTHER
which has a format of general. How do I get rid of 0.0.0000.
--
ndd