Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.
The first reason why you might see double square brackets in a structured reference is that the column headers they refer to contain a special character. In these cases, the extra pair of square ...