Hi I have i excel shhet one colum as imported data from another program. I
have this date format in the colum: 111504, im trying to format the cell but
i got this result: 4/14/05. With the format date 50498 the result i got is:
4/03/38.

Can anyone help me?

"Jean-Francois Boucher" wrote:

Hi I have i excel shhet one colum as imported data from another program. I
have this date format in the colum: 111504, im trying to format the cell but
i got this result: 4/14/05. With the format date 50498 the result i got is:
4/03/38.

Can anyone help me?

=Datevalue("22-Feb-05")

If you type this into a cell it will produce the result 38405 being the
number of days from 1-01-1900

Format the cells you wish to use as date cells and you can type in 38405
which will produce the result 22-02-05

The examples you quote are year 2205 and 2238 !!
Hope this helps, Al

Jean

Select the column then DataText to ColumnsNextNextColumn Data FormatDate
and MDY. Finish.

111504 returns 15/11/04 Nov 11, 2004

50498 returns 04/05/98 May 04, 1998


Gord Dibben Excel MVP

On Tue, 22 Feb 2005 05:25:04 -0800, Jean-Francois Boucher
wrote:

Hi I have i excel shhet one colum as imported data from another program. I
have this date format in the colum: 111504, im trying to format the cell but
i got this result: 4/14/05. With the format date 50498 the result i got is:
4/03/38.

Can anyone help me?