Convert to a Number
Numbers formatted as text (often imported from other systems) can cause issues in Excel.
To convert a number formatted as text into a real number that can be used in calculations use a formula like.
This will convert a number formatted as text in A1 into a real number.
NOTE: it will return an error if the value cannot be converted into a number.