from numbers to date

[Guillaume]

Hi,

I was wondering if anyone knows a way to automaticaly transform a number into a date. Ex. : I have 19980615 and I want this to be 1998-06-15, june 15 of the year 1998. I tried with the format of the cell, but that doesn't really transform the number, it just a different format on the screen. I have to transform a large number of data. Thanks.

 

[just_jon]

One way --

Book1
	A	B	C	D
1	19980615	6/15/1998
Sheet1

 

[Von Pookie]

Select the cell with the date, and go to Data\Text to columns.

Select Delimited and click next. Uncheck any delimiters that may be selected, and click next. Under Column data format, select Date, and choose YMD from the dropdown. Click Finish, and you should get a date format instead.

Hope it helps,

 

[just_jon]

... or, of course, you *could* do it the easy way ...

 

[Von Pookie]

Sorry, Jon. Your post wasn't there when I started typing that.

 

[Guillaume]

Thanks you very much, both of you. I tried the easy way, as Jon put it, and it works, miracle. This was my first time, certanly not the last.

Guillaume

 

[just_jon]

Sorry, Jon. Your post wasn't there when I started typing that.

Hey, VP -- you gave him the A-list answer; I tried to slap him with code that wasn't needed.