Excel's VALUE function - What does it do?

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.

What does the VALUE function do?

Excel's VALUE function - What does it do?

Excel's VALUE function converts a text string which represents a number to a number.

If cell A1 contains 123 (formatted as text), then

=VALUE(A1)

returns 123 (formatted as a number).

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Jennifer Mathes, Ph.D.