Selected value not updating
Most of us are used to separating function arguments with commas. The character you use to separate arguments depends on the List Separator set in your Regional Settings.The visual indicators of text-numbers are as follows: The below screenshot shows that even a simple Excel SUM formula may not work because of numbers formatted as text: To fix this, select all problematic cells, click the warning sign, and then click Convert to Number: In some cases, however, neither green triangles nor the warning sign appear in cells.For example, if you enclose numeric values in double quotes in your formulas, Excel assumes you want to output a text string rather than a number.Please see How to highlight and match parenthesis pairs for more information.
All Excel functions have one or more required arguments.
Remember that in Excel formulas, a comma is typically used to separate a function's arguments, and the dollar sign makes an absolute cell reference.
Selected value not updating comments