Thread: # sign
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Duplatt Duplatt is offline
external usenet poster
 
Posts: 33
Default # sign

I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number (general) in Sheet1!$B$21
The formula shows ok and if i put the curser on the cell it shows the number
in the referred to cell.
I know I must have done something wrong, but don't know what.
How can I get the numbers to show?
Thank You
Duane