View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
D_Mac
 
Posts: n/a
Default Problem with multiple # in cell - help please

I am creating data spreadsheets in this program. In some cells, the
information shows up as #####, while in others it shows up fine. Is there a
way to get rid of the ####s? The content is text and numeric, though, and the
batch loader the files are loaded into don't recognize the ####.

I just went and looked at the data in the cells where the multiple #s are
showing

up. Sometimes it's body text (sentences, text, that kind of thing) with no
numbers. Sometimes there are numbers in with the body text. But it doesn't
seem to be consistent when the #s appear in the cells.

Thanks again. I hope you guys can help.