You already know that the main purpose of the VALUE function in Excel is to change text strings to numeric values. ![]() The below examples show how this works in practice. In some situations, however, you need to explicitly tell Excel to do so. How to use VALUE function in Excel - formula examplesĪs pointed our earlier, in most situations Excel converts text to numbers automatically when necessary. ![]() In the screenshot below, please notice the original left-aligned strings in column A and the converted right-aligned numbers in column B: The VALUE function was introduced in Excel 2007 and is available in Excel 2010, Excel 2013, Excel 2016 and later versions.įor example, to convert text in A2 to number, you use this formula: ![]() Where text is a text string enclosed in quotation marks or a reference to a cell containing the text to be changed to a number.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |