Excel 2007 VALUE Function
Monday July 6, 2009
Sometimes when data is imported or copied into an Excel spreadsheet numbers get converted to labels.
This means that they cannot be used in formulas or functions.
To change them back into values, so that they can be used in calculations, use the VALUE function.
To find out the details of using this function, read the article on the Excel 2007 VALUE Function.
Related Articles
This means that they cannot be used in formulas or functions.
To change them back into values, so that they can be used in calculations, use the VALUE function.
To find out the details of using this function, read the article on the Excel 2007 VALUE Function.
Related Articles
Comments
Thanks Ted…I use the value function almost daily, many people will find it useful for systems and old software that export to excel in label format rather than a number.