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.

The default format for the TODAY function ... instructed Excel to ignore this error, then the contents of the cell are text. If the values are text, you must convert them to numbers immediately.