Using Excel’s VALUE() function

ByMisterFoxOnline

May 28, 2024 #Excel function, #Excel tutorial, #VALUE()

Excel’s VALUE() function is a simple function easily illustrated by examples.

In this tutorial:

Syntax
Examples

Required knowledge:

Mastering Excel functions

1. Syntax

=VALUE(text)

Where text is a cell which contains a number stored as text.

Returns a value.

2. Examples

Column A is formatted as Text. Cell B2 contains the function =VALUE(A2) which has been copied down to B15. Cell A2 is null, cell A3 contains spaces.

Excel's VALUE() function examples. — Excel’s VALUE() function examples.

Microsoft Support (no date) VALUE function. Available at: https://support.microsoft.com/en-us/office/value-function-257d0108-07dc-437d-ae1c-bc2d3953d8c2 (Accessed: 27 May 2024).

Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher who has just finished training as a Young Engineers instructor. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.