FriendsEAT New York

FriendsEat

Category

How do you use the VALUE function in MS Excel?


In Microsoft Excel how do you use the function VALUE?

In: Technology | 548 days ago

Alternative Question

No similar questions found.

Click here to create your own alternative question

Answers (2)


         The value function converts a text representing a number into a number. The text can be a constant, date or time. The usage syntax for the value function is =value("TEXT") For example, =value("21:00:00") returns 0.875 because it 0.875th of a full day. You can also enter the name of a cell instead of TEXT

99 days ago

         This function converts a text string represented by a number to a number. Syntax: VALUE(text) where "text" is the text enclosed in quotation marks or a reference to a cell containing the text you want to convert. Example: VALUE("$123") returns the number equivalent of the string 123.

229 days ago

RSS Feeds & Links

Popular

Copyright 2009. Binary Bits, LLC.