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.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.