1. Computing
Ted French

Excel VALUE Function

By February 8, 2014

Follow me on:

Sometimes when data is imported or copied into an Excel spreadsheet numbers get converted to text.

This means that they cannot be used in formulas or functions such as the SUM or AVERAGE functions.

Changing the data back into numbers, so that they can be used in calculations, can be done with the VALUE function.

To find out the details on how to do this read the short tutorial on the Excel VALUE Function.

Related Tutorials

January 5, 2009 at 11:00 pm
(1) Joe says:

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.

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.