Windows 10: how to convert text to number

how to convert text to number

:)

 

In CALC convert text date to number date

The field shows as text 10/11/1985. How can I convert it to number?

 

In CALC convert text date to number date

The reason for the conversion was to put a long column of text dates, like 03/10/1998 in chronological order.

After much searching, I found this gem on my hard drive. It works for OpenOffice Calc so it may work for Excel.

If you want to apply a numerical format to a column of numbers in text format (for example, text "000123" becomes number "123"), do the following:

1. Select the column in which the digits are found in text format. Set the cell format in that column as "Number".
   
2. Choose Edit - Find & Replace
   
3. In the Search for box, enter ^[0-9]
   
4. In the Replace with box, enter &
   
5. Check Regular expressions
   
6. Check Current selection only
   
7. Click Replace All

 

In CALC convert text date to number date

Excel Online will convert date 10/11/1985 to a number (31361) which is different from Epoch timestamp.

Excel counts days since Jan 1 1900 (which = 1 not zero and current date is included) not seconds since 1st Jan 1970 like Epoch. See Excel: How Excel stores dates and times - OfficeTuts.net

Like @tony K said depends what number you want but you could use Calculator app to convert to Excel format by using the Date Calculation option (click on the 3 lines in top left) and working out the number of days between 30 December 1899 and whatever date you want.