In: Technology | 548 days ago
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 agoThis 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