More Excel Woes.

  t.long 13:47 12 Oct 2004

I am working on a spreedsheet in Excel, however all the cells were auto sums are present merely display #####. The cells that feed them the data are fine and the sums work out fine, the formating is set to number by the way. When I set the format to general then the correct answear comes up and no #s appear. However I wanted the format as number for decimal places and so it automaticly added the '0'. Is there anything I can do here?

  hillybilly 13:50 12 Oct 2004

I think you need to make your colunms a bit wider.

  VoG II 13:50 12 Oct 2004

Make the column wider or reduce the font size.

  t.long 13:54 12 Oct 2004

Thank you.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

Political cartoons in 2017: Chris Riddell, Rebecca Hendin and Dave Brown on what it’s like to…

The best iPhone for 2017

Tennis : comment regarder la finale de la Coupe Davis 2017 ?