Excel: Convert numbers to date

Question

Jul 17, 2007, 11:44 AM

Smith21000

Junior Member

Join Date: Jan 2007

Posts: 72

Excel: Convert numbers to date

I'm using excel 07 and I have a cell containing the number 11291997 which represents 11/29/1997. How can I convert this to a date format. The 11291197 is number formatted. Any suggestions would help, thanks!

Answers

Jul 17, 2007, 12:28 PM	#2

ScottGem

Computer Expert and Renaissance Man

Join Date: Jan 2003

Location: LI, NY - USA

Posts: 33,630

Pay to call ScottGem for advice ($.75/min)

Well if its number formatted you have a problem. You need to convert it to a string. What happens if the date is single digits for month and day? You will have a problem converting 881998 (Aug 8 1998) and 1052000 (Oct 5 2000) if the dates are not formatted mmddyyyy. The latter sample could be Oct 5 or Jan 5.

IF the formatt was mmddyyyy, then you would use the DateValue() function like this:

=Date(Value(Right(string,4)), Value(Left(string,2)), Value(Mid(3,2,string)))

Similar Sponsors

Thread Tools

Show Printable Version

Email this Page

Similar Threads

Finding Final Date in Excel
(2 replies)

to-date total based on current date
(1 replies)

MS Excel spreadsheet changing numbers
(1 replies)

Problem in convert the value as Date datatype using Javascript
(0 replies)

F-1 to H-1, what's the start date of H-1? Should be approval date or visa issue day?
(3 replies)

Search this Thread

Advanced Search

Bookmarks



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!