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.
=A1*1
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.
Please note: I reserve the right to delete comments that are offensive or off-topic.