This seems obvious, but I cannot find the answer anywhere. Is there an easy way to globally change the contents of cells that are forced to text by an apostrophe ( 'string ) to numbers without the apostrophe that can be sorted ( string )?
Thanks!
-- Donald
[Solved] Change cells with forced text to numbers
[Solved] Change cells with forced text to numbers
Last edited by Hagar Delest on Mon Mar 08, 2010 1:48 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Re: change cells with forced text to numbers
The easiest way is to use the VALUE() function to create a new column of numbers.DonaldFR wrote:This seems obvious, but I cannot find the answer anywhere. Is there an easy way to globally change the contents of cells that are forced to text by an apostrophe ( 'string ) to numbers without the apostrophe that can be sorted ( string )?
Thanks!
-- Donald
LibreOffice 7.3.7. 2; Ubuntu 22.04
Re: change cells with forced text to numbers
Thanks, but that doesn't help in my situation (I don't think!).
I've got a colum of British format dates ('DD/MM/YYYY) that I need to change to DD/MM/YYYY in a form that Calc would recognize as a date.
Any ideas?
Thanks!
-- Donald
I've got a colum of British format dates ('DD/MM/YYYY) that I need to change to DD/MM/YYYY in a form that Calc would recognize as a date.
Any ideas?
Thanks!
-- Donald
Open Office 3.1.1. under Ubuntu 9.10
Re: change cells with forced text to numbers
1) Select the cells you want to convert
2) Make sure the cells have any number format other than "Text" ("@").
3) Data > Text to Columns
3a) Separated by: Tab (any character not present in the column datsa is OK)
3b) Select the column in the preview and change the column type to Date: D/M/Y
4) Click OK
2) Make sure the cells have any number format other than "Text" ("@").
3) Data > Text to Columns
3a) Separated by: Tab (any character not present in the column datsa is OK)
3b) Select the column in the preview and change the column type to Date: D/M/Y
4) Click OK
AOO4/LO5 • Linux • Fedora 23
Re: change cells with forced text to numbers
Hi Donald
=DATEVALUE(A1) and then you must format the cell to a dateformat.
wolfgang
=DATEVALUE(A1) and then you must format the cell to a dateformat.
wolfgang
OOo 3.1.1, 3.2.0 SuSE Linux 11.2, Win XPSP2, Win 7
Re: change cells with forced text to numbers
Another possible route is here:
To get rid of ' before a number .... (seen when some Excel files are opened in Open Office):
Alt,E,F and in search type ".+" and replace with "&" and tick regular expressions.
To get rid of ' before a number .... (seen when some Excel files are opened in Open Office):
Alt,E,F and in search type ".+" and replace with "&" and tick regular expressions.
LibreOffice 5.2.1.2 on Lubuntu 16.04 (Openbox)
Re: change cells with forced text to numbers
I tried most of these options, and the one by acknak worked. Thank you all!
-- Donald
-- Donald
Open Office 3.1.1. under Ubuntu 9.10