VALUE Function - Convert number displayed as Text to Value

Excel mixes up data types at times and sees numerical data as text data. For eg. when you import data into Excel from another program / internet.

In such a situation, functions like SUM or AVERAGE lead to calculation errors.

VALUE Function converts numbers seen as Text to Values and make them function normally for SUM, AVERAGE and other numerical functions.

The syntax for the VALUE function is:

= VALUE ( Text )

Text – Data to be converted. It can be actual data in quotation marks or a cell reference.