Tullio Facchinetti
Tag cloud
Picture wall
Daily
RSS Feed
  • RSS Feed
  • ATOM Feed
  • Daily Feed
Filters

Links per page

  • 20 links
  • 50 links
  • 100 links

Display

Filter untagged links
2 results tagged libreoffice  ✕
Converting a Text String to a Number in Calc https://neowiki.neooffice.org/index.php/Converting_a_Text_String_to_a_Number_in_Calc
Wed 07 Aug 2019 06:47:49 PM CEST
QRCode

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 Values
  • Click Replace All

Using the VALUE Function

The function =VALUE(.) returns the numerical value of a string.

howto libreoffice
Nine essential LibreOffice extensions http://www.openlogic.com/wazi/bid/322833/nine-essential-libreoffice-extensions
Wed 06 Nov 2013 11:48:45 PM CET
QRCode

Early in its development, OpenOffice.org made a policy of encouraging extensions to augment the funtionality of the office suite. Today OpenOffice.or

libreoffice
3654 links
Shaarli - The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community - Theme by kalvn