![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Functions > Text > VALUE |
VALUE(text) |
| Returns the text string that represents a number to a number. |
| text | The text string that represents a number. |
| REMARKS |
| Text can be in any of the constant number, date, or time formats recognized by Microsoft Excel. If text is not in one of these formats, then #VALUE! is returned. | ||
| The text enclosed in quotation marks or a reference to a cell containing the text you want to convert. | ||
| This function is provided for compatibility with other spreadsheet programs. | ||
| You do not generally need to use this function because Microsoft Excel automatically converts text to numbers as necessary. |
| EXAMPLES |
|
| Functions - V | Index - V | Text Manipulation | Office Online |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |