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.
Excel's VALUE function converts a text string which represents a number to a number.
If cell A1 contains 123 (formatted as text), then
returns 123 (formatted as a number).