More Excel Woes.

  t.long 13:47 12 Oct 04
Locked

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 04

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

  VoG II 13:50 12 Oct 04

Make the column wider or reduce the font size.

  t.long 13:54 12 Oct 04

Thank you.

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

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…