Unfortunately you didn't mention which table from the website you are using, so I just picked one. convert list to numeric. The alphabetical list of all the units that are available for conversion on www. The TO_NUMBER function converts a formatted TEXT or NTEXT expression to a number. However, + uses the internal ToPrimitive(Number) operation (except for dates ), while String() uses ToPrimitive(String). 0" I'd like to find a function that generates the following object from 'str'. Perhaps you have seen a hex code on a web page and would like to use that color in your photo editing software. You can use the functions int and float to convert to integers or floating point numbers. Re: Convert List Of Sequential Numbers Into Ranges The following function converts multiple sequences of 3 or more consecutive numbers in a list to a string consisting of the first & last numbers joined by a hyphen. Skills: Excel , Matlab and Mathematica. Lists can have any structure and size and can routinely involve even millions of elements. Hi I've had a look at a lot of other qns/answers and haven't been able to resolve coercing from list form to numeric form. 10 cm to ft = 0. Browse for the file you want to convert to PDF by clicking on File->Open or pressing Ctrl+O. boxed() Use Collectors. With this approach, a version of Mathematica running on one computer system produces files that can be read by a version running on any computer system. Select VALUE in the list to bring up the function's dialog box. It is another formula-free way to convert text to number in Excel. If it is a list of strings, you may simply use join: >>>; my. Even though MS Forms allows you to specify that a field has to be a number, it seems to pass to flow as a text. Also, notice that the result is still expressed as a fraction, not as a decimal number. Convert slide text to a SmartArt graphic. If something here is from the net, I try to make sure I put a reference or credit to where I saw it, else it will be something I wrote myself, in that case, all blames to me. I am reading this material to understand the basics of number system. 71828 and N[40!] returns 8:15915 1047. How to Convert a List to a Table in Microsoft Excel. Calculator Use. Unsure which solution is best for your company? Find out which tool is better with a detailed comparison of wolfram-mathematica & funnel-science. In this post, we will see how to convert List of String to List of Integer in Java. You may have copied a column of text from Excel, Open Office or notepad. IITS has enabled a new feature in Duo called ‘Remember My Device’. Convert from a Fraction to a Decimal Fractions and decimals represent the same things: numbers that are not whole numbers. Consider the expression (x+1)2. This is one of the most common ways to convert data types in Oracle SQL. I need to have a program that would convert daily data to monthly averages, and then output the results into an excel file. 0_01/jre\ gtint :tL;tH=f %Jn! [email protected]@ Wrote%dof%d if($compAFM){ -ktkeyboardtype =zL" filesystem-list \renewcommand{\theequation}{\#} L;==_1 =JU* L9cHf lp. Output: 123 Approach #3 : Using map() Another approach to convert a list of multiple integers into a single integer is to use map() function of Python with str function to convert the Integer list to string list. Mathematica sees this as one string, this is important, not as a list of strings. HTML Table to CSV/Excel Converter. Zamzar Pro Tip: If you do not have NUMBERS installed on your Mac then use Zamzar to convert it to something you can open. Since version 1. Converting from a list to numeric in R. There is some complexity here. m extension. Character arrays and string arrays store each character as a 16-bit numeric value. Newbie here struggling with GIS. Select the cells, and then click to choose a convert option. Clique number and chromatic number are NP-complete, yet Lovasz theta function can be found in polynomial time using SDP. Scientific notation is a compact way of writing very large and very small numbers. Convert fractions to decimals and percentages, work with mixed numbers and improper fractions and solve for X in fractions equations using CalculatorSoup ® online fractions calculators. NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. This gives you the opportunity to convert numbers to dates. Numbers that are stored as text can cause unexpected results. + + `` `` + Determines the channel number in which to insert the center channel. Search for jobs related to Convert urlvariables number or hire on the world's largest freelancing marketplace with 15m+ jobs. Sometimes users need to convert the Non-number values (like, YES/NO, date/time) into Numeric value. Re: Convert List Of Sequential Numbers Into Ranges The following function converts multiple sequences of 3 or more consecutive numbers in a list to a string consisting of the first & last numbers joined by a hyphen. Click here to use the Hex to RGB converter page. It can be really easy to. SageMath (which I started in 2004) is in fact a Python library targeted at professional mathematicians (mainly research in pure math), and is much stronger than Mathematica in many areas, including number theory, algebraic combinatorics and algebraic dynamics. If you do happen to have the answer, please tell me and I will thank you. Are newlines permitted in string literals. Here are the steps to this. If I then create a Powerapp from the list the two calulated fields are created as Txt fields and display the calculated fields as follows. Hence having ways to perform this task using shorthands comes handy. I am trying to map out wards for the city of Milwuakee using shapefiles found on their county website county website. The following methods can convert numbers in cells to text in Excel. Number to Text / Words Converter. The Table command can be used to generate a list of numbers using a predefined mathematical expression. I don't want the bother of the list numbers changing when editing the document. as decimal, sometimes are null) to number from xml on server side. See Where Numbers Go on a Number-Line - powered by WebMath. Reverse geocoding is the process to convert the latitude and longitude coordinates to a readable address. We might need quite a few terms in the expansion to approxi-mate this. Hi, I have just converted a range of numbers, that were stored as text, to number. Table "Path" with only one row with path to folder. This function converts Python objects of various types to Tensor objects. This function is typically used to convert the formatted numerical output of one application (which includes currency symbols, decimal markers, thousands group markers, and so forth) so that it can be used as input to another application. The printing company requires a CMYK pdf file that uses the ISO Coated v2 (ECI) ICC profile. as decimal, sometimes are null) to number from xml on server side. Converting Numbers to Strings. 42), or as a string (ex. Converting objects to string Both approaches first convert an object to a primitive, before converting that primitive to string. This is the format that will be used to convert string1 to a number. stream() function. The main difference between CAST and TO_NUMBER is that CAST is ANSI compliant, and TO_NUMBER (along with the other TO_* functions) are. Scientific notation is a compact way of writing very large and very small numbers. Of the most common issues that I see when I review slow code is that the programmer has inadvertently asked Mathematica to do things more carefully than needed. This Excel tutorial explains how to use the Excel CONVERT function with syntax and examples. 4 Appendix A. C Programming & Visual Basic Projects for $30 - $250. Character arrays and string arrays store each character as a 16-bit numeric value. Try 102 / 9 You get the result 34 / 3 You see that Mathematica reduced the fraction to its simplest form by cancelling out common factors in the numerator and denominator. Also added a number of new exports. 4 I keep tellingMathematica a number is complex, but it persists in treating it as real. I am basically trying to convert each item in the array into a pandas data frame which has four columns. So I would suggest to write "I can't find a converter to convert PDF to EPS either in MikTeX or TeXLive" (as suggested in the TeX. Convert from Numeric Values to Character Array Function Summary. Click here to use the Hex to RGB converter page. I am using an MS Forms form to trigger an MS Flow which will transfer the input into a new list item in sharepoint. This section explores the basic concepts behind numerical calculations using Mathematica. Converting list of strings to a string using str. SageMath (which I started in 2004) is in fact a Python library targeted at professional mathematicians (mainly research in pure math), and is much stronger than Mathematica in many areas, including number theory, algebraic combinatorics and algebraic dynamics. And so you can change it to: def create_list(data): return list(str(data)) I find it easier to read create_command if you merge some of the lines together:. Sometimes users need to convert the Non-number values (like, YES/NO, date/time) into Numeric value. Learn how to quickly convert a list in Word into a formatted table. This can be particularly useful since functions in the Wolfram Language often take a flat sequence of arguments instead of an argument list, so use of Sequence allows list-represented data to be easily spliced into other functions. As you probably know, Excel stores dates and times as serial numbers and it is only a cell's formatting that forces a number to be displayed as a date. As we indicated earlier, we need to convert the numbers to strings. 005555556π = 0. Reduce fractions to lowest terms, simplify, compare and order fractions. Convert class. Where the sum of measured temperatures is found by adding up every measurement. Convert string to number with Text to Columns. Hi, Im trying to convert a table (manually defined, in another query) to a list of lists but I have trouble understanding the Table. Convert fractions to decimals and percentages, work with mixed numbers and improper fractions and solve for X in fractions equations using CalculatorSoup ® online fractions calculators. It can be really easy to. I use getSymbols to download historical information over an environment with 200 tickers but I cannot seem to keep the date information from becoming an index. This is the format that will be used to convert string1 to a number. Press button, get result. Release history: [0. Is there a quick and easy way to convert a floating number, in MATHEMATICA? For example: 234 = 0. It joins all the elements in iterable sequence by separator_string. The paragraph stays. Hi, I have a single column of numbers, some single entries and others are a range of numbers. For some computations, you might be tempted to convert a string to a list of characters and then operate on the list using some list manipulation functions. Mathematica also includes integration for Quantity in system functions, including numeric and symbolic calculations, statistics, and visualizations. Unsure which solution is best for your company? Find out which tool is better with a detailed comparison of wolfram-mathematica & funnel-science. To remove the number from a paragraph but keep it aligned with the list, put the insertion point at the beginning of the paragraph and press Backspace to remove the number. File extensions MATLAB. SageMath (which I started in 2004) is in fact a Python library targeted at professional mathematicians (mainly research in pure math), and is much stronger than Mathematica in many areas, including number theory, algebraic combinatorics and algebraic dynamics. I would like to preface this by saying that I am new to R, so I would ask that you be patient and thorough, so that I'm not completely clueless. Get the free "Convert Complex Numbers to Polar Form" widget for your website, blog, Wordpress, Blogger, or iGoogle. To convert non-number values, you don't need to manually enter the corresponding value, Excel 2010 offers a simple formula which can evaluate any supported Non-number and show its respective number value. I'm trying to creating a formula that will take what is listed in column A and will convert into number ranges where at the end of a sequentially listing it will convert into a range and then start another sequential range. 30 cm to ft = 0. Ensure that all of the measurements are in the same temperature unit before applying this formula. If you can be be sure that only digits from 0 to 9 appear in the list, you can also use FromCharacterCode which is faster by almost two further orders of magnitude. This post will guide you how to convert column list into a comma separated list in one cell in Excel. Syntax: list = array. Unfortunately you didn't mention which table from the website you are using, so I just picked one. SageMath is a free open-source mathematics software system licensed under the GPL. Precede a number by an apostrophe and it will also be treated as text. When used for other purposes, for example to split cells, the Text to Columns wizard is a multi-step process. Can you tell me whether it's okay or not?. I'm trying to creating a formula that will take what is listed in column A and will convert into number ranges where at the end of a sequentially listing it will convert into a range and then start another sequential range. The second pattern, @{before='"Hello","1"'; after='1: Hello'}, reads as follows: expect strings where a word comes enclosed in double quotes, then a comma, and then a number enclosed in quotes; with no spaces in the string. 4 Appendix A. Learn how to quickly convert a list in Word into a formatted table. The N function can be used to compute approximate (decimal) values instead. Expressions in the Wolfram Language can be represented as strings in a variety of ways, for display, export, or processing. If something here is from the net, I try to make sure I put a reference or credit to where I saw it, else it will be something I wrote myself, in that case, all blames to me. And in this situation, you can use custom formatting. Convert column of data into semicolon separated list of data instantly with this free in-browser tool. In this article I also explain how to find the maximum element in the list and how to find the minimum element in list. I need to convert all of the ranges into single entries in separate cells. I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this: 1234 123461 123151 11321 And make them into a comma-separated list in another cell that the user can easily copy and paste into another program like so: 1234,123461,123151,11321 What is the easiest way to do this?. converted_python_number = zero_dim_example_tensor. Part 1: First, in part 1 the example initializes a new string array containing five strings. 005555556π = 0. Hi , I want to convert a my list: > myList [[1]] [1] 1 2 3 4 5 [[2]] [1] 6 7 8 [[3]] [1] 9 10 11 into something like c(1,2,3,4,5,6. Convert List to String Java example shows how to convert list to string in Java. It's free to sign up and bid on jobs. Reverse Geocoding Convert Lat Long to Address. 048511*10^6 The problem is I'm importing an XLS file that should contain only strings - the fields are set to Text in Excel - but Mathematica has its way when using Import and outputs a list containing multiple different number formats. It can convert a number from 1-100 into words. ToUInt32(String, Int32), to convert the string representation of an integer in a specified format to an unsigned 32-bit integer. The Microsoft Excel CONVERT function will convert a number from one measurement unit to another measurement unit. The Excel Text to Columns command will also convert between Excel data types. This is the nls language used to convert string1 to a number. In many cases when you import data from an external source or create a file in a different program, numbers are recognized as text in Excel. Type in your own numbers in the form to convert the units! ›› Quick conversion chart of cm to ft. The implementation below assumes the length of the array on top of the stack, and the actual items below it. join(list): It is a string method, and takes a list of things to join with the string. 000 rows, it doesn't matter if they're. toList() to accumulate the input elements into a new List. The latest Tweets from Mathematica Tips (@MathematicaTip). Convert a number to a representation using a given radix. Ensure that all of the measurements are in the same temperature unit before applying this formula. Convert list to text Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. If I then create a Powerapp from the list the two calulated fields are created as Txt fields and display the calculated fields as follows. Mathematica provides a variety of operations that enable one to manipulate the structure of such a list. It can convert a number from 1-100 into words. Items: We get a view of the dictionary with items() and then convert that to a list. I am using an MS Forms form to trigger an MS Flow which will transfer the input into a new list item in sharepoint. assuming that you want those 7-digits integer to be in the list individually, you'd like to do this: [code]a = 1234567 #your seven digit integer your_list = [] for i in str(a): your_list. Learn how to quickly convert a list in Word into a formatted table. InMathematica, this number is denoted by a capitalletter,asI. This gives you the opportunity to convert numbers to dates. As we move further right, every number place gets 2 times smaller (half as big). Converting from a list to numeric in R. The Wolfram Language provides several ways to control the display of these numbers. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. C = coated paper. It joins all the elements in iterable sequence by separator_string. See also our One’s Complement Calculator. There are various situation we might encounter when a list is given and we convert it to string. Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. A SmartArt graphic is a visual representation of your information that you can fully customize. Use an easy side-by-side layout to quickly compare their features, pricing and integrations. I thought I would share the list of things that I look for first when trying to optimize Mathematica code. The main difference between CAST and TO_NUMBER is that CAST is ANSI compliant, and TO_NUMBER (along with the other TO_* functions) are. Click "Convert" to convert your NUMBERS file. Even roman465's somewhat creative solution to first convert the whole expression to a string and to remove the undesired parts afterwards is five times faster. + + `` `` + Determines the channel number in which to insert the center channel. Convert list to text Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. This is done by first select the graphics, then select Convert to PICT from the graph menu. 5 to binary floating point, but im struggling to find the exponent. The input variable number would be more descriptive than test. ToPrimitive(Number): To convert an object obj to a primitive, invoke obj. Getting numbers as a result of a formula (such as LEFT, RIGHT, or MID) If you extract the numerical part of a text string (or even a part of a number) using the TEXT functions, the result is a number in the text format. This selection will show you where a number belongs on the number line. 4 I keep telling Mathematica a number is complex, but it persists in treating it as real. The join method (called on a given string) can be used to concatenate a list of strings. This list is created by collecting extension information reported by users through the 'send report' option of FileTypesMan utility. Scientific notation is a compact way of writing very large and very small numbers. For some computations, you might be tempted to convert a string to a list of characters and then operate on the list using some list manipulation functions. Thus any fractional number can be represented in decimal notation. In this article, I tried to sum up some of the processes on how to convert text to numbers in Excel. Integers and floating-point numbers. The task is to write a program to transform a decimal number into a fraction in lowest terms. I tried to specify return. Convert from Character Code. Then use the procedure described above to display the PostScript as a Mathematica graphic. However, + uses the internal ToPrimitive(Number) operation (except for dates ), while String() uses ToPrimitive(String). To convert text to a table or a table to text, start by clicking the Show/Hide paragraph mark on the Home tab so you can see how text is separated in your document. For doing so, you may need to change a number into text. To use Excel Text to Columns to convert text to numbers: Select the range of cell(s) that you want to convert (these must not span more than one column). The following methods can convert numbers in cells to text in Excel. Is there any efficient way of achieving this? I could send an SQL string to a function that would convert a list of numbers into a string as above. How do I convert a column into a comma separated list with a formula in Excel. In Mathematica, what you have is a decimal number that happens to make use of only 1 and 0 digits. In the example shown, the formula in C5 is: = TEXT ( B5 , "0" ) Background Normally, you want to maintain numeric values in Excel, because they can be used in formulas. It may contain constants, variables, certain "well-known" operations (e. Usually the list item ID number is used to do this. See Where Numbers Go on a Number-Line - powered by WebMath. The first digit on the right means halves (1/2). Convert Text to a Number Using Excel Text to Columns. Re: Convert List Of Sequential Numbers Into Ranges The following function converts multiple sequences of 3 or more consecutive numbers in a list to a string consisting of the first & last numbers joined by a hyphen. They could be sorted in many ways. From unit conversion to dimensional analysis, Mathematica provides you with all the tools you need to work with, and extract properties from, units and quantities. Convert numbers in automatic lists to permanent numbers I have created a series of numbered lists in my document (they refer to illustrations with numbered callouts). I use either convert or case and it cuts off my leading zero digits. I use getSymbols to download historical information over an environment with 200 tickers but I cannot seem to keep the date information from becoming an index. 1 Note: Functions for converting to date, numeric, string, and timestamp data types can be found through the related links. I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this: 1234 123461 123151 11321 And make them into a comma-separated list in another cell. Introduction to Mathematica Commands Numerical approximation Mathematica returns exact answers whenever possible. Reverse geocoding is the process to convert the latitude and longitude coordinates to a readable address. However, this command will only work on one column at a time. File extensions MATLAB. We can use Mathematica to compute : In[27]:= Exp 100 N Out[27]= 2. If it is of use, the list is originally drawn from a factor (and is 1x33 r. Unsure which solution is best for your company? Find out which tool is better with a detailed comparison of wolfram-mathematica & funnel-science. as decimal, sometimes are null) to number from xml on server side. We will see two Python programs, first program does the conversion using a user defined function and in the second program we are using a in-built function bin() for the decimal to binary conversion. Here's a quick way to convert the text in a bulleted list to a SmartArt graphic to show your message visually in PowerPoint. Explore Some Color. How to use Numbers Converter Select the unit to convert from in the input units list. Converting objects to string Both approaches first convert an object to a primitive, before converting that primitive to string. Use an easy side-by-side layout to quickly compare their features, pricing and integrations. There are 3 parts to this example. Mathematica sees this as one string, this is important, not as a list of strings. To convert the zero-dimensional PyTorch tensor to a Python number, let's use PyTorch's item operation. matmul(arg, arg) + arg # The following. How to convert decimal numbers to roman numerals. Choose File > Export To, then select the format. MATHEMATICA. What it can do for you. I am following the thread here with some succe. This Excel tutorial explains how to use the Excel CONVERT function with syntax and examples. Convert a number to USD currency and check writing amounts rounded to 2 decimal places. The genetic optimization technique that I'm using returns it's individuals as a list, so I am extracting the integers as follows: Problem: Take the boolean/binary list. The motivation is the fast reading of binary files. File extensions MATLAB. Dataframe does not quite give me what I am looking for. The Wolfram Language provides several ways to control the display of these numbers. Syntax: list = array. Interconversion between data types is facilitated by python libraries quite easily. If something here is from the net, I try to make sure I put a reference or credit to where I saw it, else it will be something I wrote myself, in that case, all blames to me. Example 3: 158 x 100 = 15800%. If it is a list of strings, you may simply use join: >>>; my. The main thing that I dont understand is how to define the combiner function that turns the rows into lists. Convert string to list?. Explore Some Color. class to ". Converting list of strings to a string using str. Clique number and chromatic number are NP-complete, yet Lovasz theta function can be found in polynomial time using SDP. Is there a quick and easy way to convert a floating number, in MATHEMATICA? For example: 234 = 0. This is what I don't like, there is no direct generic way to convert Collections to array, since array doesn't support Generics, you can not create T[], which means you have to rely on overloaded method to convert list of integers to int array, list of Float to float array, List of Double to double array and so on May 15, 2013 at 8:17 PM. Lovasz theta function is an estimate of independence number of the graph, and theta of graph's complement is guaranteed to lie between graphs's clique number and its chromatic number. Use this page to learn how to convert between centimetres and feet. Array, List. How to: Convert a String to a Number (C# Programming Guide) 02/11/2019; 4 minutes to read +6; In this article. Consider the expression (x+1)2. May currently be low + quality as it does not implement a high-pass filter for proper extraction + yet, but averages and halves the channels instead. Since all Excel functions that change text to date return a number as a result, let's have a closer look at converting numbers to dates first. InMathematica, this number is denoted by a capitalletter,asI. In Mathematica, what you have is a decimal number that happens to make use of only 1 and 0 digits. > Suppose that. To convert that value to a negative number, enter this formula in a blank cell: =LEFT(H4,LEN(H4)-1)*-1. create_list is building a list of all the items in the string form of data. append(i) [/code]if you print your_list you'd see output as. Press button, get result. Now, let's see how to tackle such cases. Converting Numbers to Strings. Developers wishing to create a new prelude should use @[email protected] What it can do for you. 0, and 8048511 to 8. I use getSymbols to download historical information over an environment with 200 tickers but I cannot seem to keep the date information from becoming an index. Mathematica provides a variety of operations that enable one to manipulate the structure of such a list. Lists can have any structure and size and can routinely involve even millions of elements. To use Excel Text to Columns to convert text to numbers: Select the range of cell(s) that you want to convert (these must not span more than one column). How to convert a NUMBERS to a XLS file? Choose the NUMBERS file that you want to convert. Learn how to quickly convert a list in Word into a formatted table. Thanks in advance. The first three def statements, once, ten and hundred could be put in a dictionary in a list or tulpe format and a smaller program could provide the same information as all of the if statements. nb extension. Consider the expression (x+1)2. How to convert horizontal list to vertical list in Excel? Supposing you have a row of data and in some times, you need to convert this horizontal list to a vertical list (a column). The genetic optimization technique that I'm using returns it's individuals as a list, so I am extracting the integers as follows: Problem: Take the boolean/binary list. Hi, Im trying to convert a table (manually defined, in another query) to a list of lists but I have trouble understanding the Table. Usually the PostScript version can be discarded. We start by converting given List to Stream using List. Am using an A2k app in which I want to convert a list of numbers (1,2,3,4,5,8,9,10,12) into something that looks like (1-5, 8-9, 12). Logical symbols Logical operators and connectors are summarized below:. Precede a number by an apostrophe and it will also be treated as text. How to convert column list to comma separated list in Excel? If you want to convert a column list of data to a list separated by comma or other separators, and output the result into a cell as shown as below, you can get it done by CONCATENATE function or running a VBA in Excel. I am trying to convert +3. We can convert numbers to strings through using the str() method. The easiest way to convert time to decimal in Excel is to multiply the original time value by the. I try to paste path to folder from table. Unnecessary use. The printing company requires a CMYK pdf file that uses the ISO Coated v2 (ECI) ICC profile. – Roger Bacon This blog is not related to the Mathematica software produced by Wolfram Research. The number (or release number) is the version reported by Concurrent License Manager program FLEXlm. Unsure which solution is best for your company? Find out which tool is better with a detailed comparison of wolfram-mathematica & funnel-science. But the problem of converting the entire list of string to integers is quite common in development domain. The join method (called on a given string) can be used to concatenate a list of strings. What's wrong?5 2. I have a list such as: a = {1, 2, 4, 3}; and I want to get the 'number' of the list. For the things of this world cannot be made known without a knowledge of mathematics. Lists are great, but sometimes, a table is better. It can be inconvenient. For example: import numpy as np def my_func(arg): arg = tf. To convert text to a table or a table to text, start by clicking the Show/Hide paragraph mark on the Home tab so you can see how text is separated in your document. Convert Text to a Number Using Excel Text to Columns. First of all, select the range of the cells you need to convert into positive numbers. The Wolfram Language allows programmers to operate at a significantly higher level than ever before, by leveraging built-in computational intelligence that relies on a vast depth of algorithms and real-world knowledge carefully integrated over three decades. Online conversion calculator that allows you to convert any number into text (or) words formats. For example, my input can be 4545 or -4545, I need the out come to be positive value 4545. This gives you the opportunity to convert numbers to dates.