[Solved] LEN function not working

[i75Dave]

In column A I have a list of email addresses, and in Column B I want to list the length of each address in A. For example,
A1 = johnsmith@cinci.com

Using the function wizard, in cell B1 I have entered =LEN(A1), but the function does not calculate the number "19" Instead, when I enter it, B1 just displays the function as text, i.e. "=LEN(A1)"

I have tried changing the function to "=LEN(+A1)"
I have formatted cols A and B so they are Text.
I've even rebooted my computer to ensure there are no memory problems.
All to no avail.

Can somebody please help me?

Thanks,

Dave.

[Villeroy]

menu:View>Highlight Values [Ctrl+F8]
If B1 appears in green font, the formula is correctly evaluated but: menu:Tools>Options>Calc>View:Display Formulas is turned on which is only useful for debugging.
If B1 appears in black font, B1 may is formatted as literal text. See number format dialog.

[i75Dave]

Thanks Villeroy,

I turned on Value-Highlighting and the email addresses in col A were black. So I opened up a new col and converted the emails to text [=TEXT(A1;50) ] in col B. The LEN function now returns the number of characters correctly.
Thanks for your help.
Dave.