Problem with 'LEN' in excel

  steviegee 15:26 17 Jan 2011
Locked

I am using LEN to count the characters in cells but when I select ok the cell just keeps the formula in it rather than returning the amount of characters. Why is this and how can I rectify it please. Thanks.

  VoG II 15:29 17 Jan 2011

Make sure that the cell is formatted as General then re-enter the formula.

  steviegee 15:37 17 Jan 2011

Thanks.

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?