In order to convert text strings to number format, there are two possibilities
Find & Replaceā¦
submenu^[0-9\-]
in the Search
for fieldReplace
with field, enter &
Regular expressions
checkboxSearch
in listbox to Values
Replace All
The function =VALUE(.)
returns the numerical value of a string.
Early in its development, OpenOffice.org made a policy of encouraging extensions to augment the funtionality of the office suite. Today OpenOffice.or