In order to convert text strings to number format, there are two possibilities
- Use the Find & Replace function
- Use the VALUE function.
Using the Find & Replace Function
- Select the cell range which contains text strings
- Choose the Edit menu then the
Find & Replace… submenu
- In the Find & Replace window, enter
^[0-9\-] in the
Search for field
- In the
Replace with field, enter
- Select the
Regular expressions checkbox
- Set the
Search in listbox to
Using the VALUE 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
Are you sure you want to delete this link?
The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community