answersLogoWhite

0

An example is given below, where 111013 is in cell A1:

=DATE(RIGHT(A1,2),MID(A1,3,2),LEFT(A1,2))

Further information is given in the related link.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

How do you Convert Tally 7.2 xml data into Excel Format?

tally 7.2 data convert into excel


Complicated data can be delivered in what format by using an excel chart?

visual format


Can you change the way data in table format is displayed?

This question is in many categories that may require different answers. In Excel you can use many formats to display your data and change whenever you like.


How do you write test scenarios on a xls format?

XLS is the file extension for MS Excel 2003 and earlier. If you want to save something in XLS format, then put the scenario data in Excel and save in Excel 2003 format.


How do you write test scenarios on a XL?

XLS is the file extension for MS Excel 2003 and earlier. If you want to save something in XLS format, then put the scenario data in Excel and save in Excel 2003 format.


How do you export data from a query to Excel?

Create the report in a tab delimited format. It may have a suffix like txt or rpt. In Excel use the "Open" command. You will get a panel that allows you to refine where the column breaks are and define the format of the columns. Once this is done the data will be in Excel. Just save as a standard Excel file.


How can you transfer your data from one Excel file to another file in another format?

You can convert an Excel file to many different formats. Just Save As and select the format you like.


How do you extract a data in Microsoft Excel?

Not sure if you want to know how to export data from Excel or import data into Excel. Either way, the answer depends on what you are trying to do. You can export data from Excel by using the SaveAs option to save the file in a format you choose. If you are trying to use another program to extract data from Excel, you will need to use the options available to that specific program.


How do you export data from a Dos ver 5 database to Excel?

A good way is to export from a database is to save as CSV format (or some sort of comma-delimited text format), then open Excel and import the file into Excel.


How do you change the colour of the scatter dots on a Excel spreadsheet?

Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.Right click on any dot. Choose the Format Data Series option and in the Patterns section you can change the colours.


Which button formats data as a table in Excel?

In Excel 2007, use the "Format as Table" button in the Styles section of the Home tab.


You want to save Excel numeric data into gwbasic format?

Not sure what you are trying to do. GWBasic is a programming language; Excel is a spreadsheet. If you like, just copy data from Excel to your GWBasic editing program and reformat, as needed.