The LEN function calculates the length of the string, i.e. the number ... format_text argument takes the format that needs to be applied to the value. Let us say the A2 cell in Excel contains ...

characterizes a thousand separators, while the Comma is all about the decimal point. With this being the case, Excel ... are in Text Format, and as such, we must change the value to Number Format.