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.

Huawei P10 review

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

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now