Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.

All the cells of negative numbers will become red, while the positive numbers will remain the same. You can create your own custom format in Excel to highlight negative numbers. Select the range of ...