CONVERT function - Microsoft Support
Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.
Insert Julian dates (Functions) - Microsoft Support
Use Excel functions including TEXT, TODAY, and DATEVALUE to insert or convert a date to a Julian date.
Convert dates stored as text to dates - Microsoft Support
To convert a text date in a cell to a serial number, use the DATEVALUE function. Then copy the formula, select the cells that contain the text dates, and use Paste Special to apply a date format to them. Follow these steps: Select a blank cell and verify that its number format is General.
Convert numbers stored as text to numbers in Excel
Use a formula to convert from text to numbers. You can use the VALUE function to return just the numeric value of the text. Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column.
Create a parameter query (Power Query) - Microsoft Support
Create a parameter that stands for a value you might frequently change, such as a server, database, folder, file name, location or filter value.
Format a date the way you want - Microsoft Support
Feb 2, 2012 · When you type something like 2/2 in a cell, Excel for the web thinks you’re typing a date and shows it as 2-Feb. But you can change the date to be shorter or longer. To see a short date like 2/2/2013, select the cell, and then click Home > Number Format Short Date.
NUMBERVALUE function - Microsoft Support
The NUMBERVALUE function syntax has the following arguments. Text Required. The text to convert to a number. Decimal_separator Optional. The character used to separate the integer and fractional part of the result. Group_separator Optional.
Date and time functions (reference) - Microsoft Support
Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.
Convert times - Microsoft Support
Here are several ways to convert time units, such as how many hours there are in 5.5 days, how many days there are in 3.45 years, or how many months are between a beginning and an ending date. Convert between time units. Convert a standard time format to a decimal number. Convert from a decimal to the standard time format. Need more help?
DATE function - Microsoft Support
To convert it into a date, the DATE function was used in conjunction with the LEFT, MID, and RIGHT functions. The DATE function creates a date. =DATE(LEFT(C2,4),MID(C2,5,2),RIGHT(C2,2))
Import or export text (.txt or .csv) files - Microsoft Support
If Excel doesn't convert a particular column of data to the format that you want, then you can convert the data after you import it. For more information, see Convert numbers stored as text to numbers and Convert dates stored as text to dates. Export data to a text file by saving it