Search : in
By :

Date formats for Excel

Last answer on Jun 18, 2009 5:37:55 pm BST Passenger 57, on Jun 18, 2009 2:58:43 pm BST 
 Report this message to moderators

Hello,
I have a database of names and other details in Dbase IV. I migrated this database to Excel, but not all the dates are coming out well. Some dates are coming out as 19881015 instead of 15/10/1988. Is there a way of correcting this?

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Date formats for Excel » in :
Verifying date format in PHP ShowVerifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
HTML forms ShowForms Interactive forms let web page authors give their pages interactive elements, such as for receiving messages from their readers, much like the reply cards found in some magazines. The reader enters information by filling in fields or clicking...
Ask your question Reply

1

 John Franco, on Jun 18, 2009 5:37:55 pm BST

Assuming 19881015 is in A1; Use DATE(year, month, day)

Do it this way:

=DATE(LEFT(A1;4);MID(A1;5;2);RIGHT(A1;2))

Source: http://www.excel-spreadsheet-authors.com/excel-number-to-dat­e.html

   
Reply to John Franco
Ask your question Reply
They need your help