Date format

[Guest]

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?

 

[Guest]

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

 

[Gord Dibben]

Jean

Select the column then Data>Text to Columns>Next>Next>Column Data Format>Date
and MDY. Finish.

111504 returns 15/11/04 Nov 11, 2004

50498 returns 04/05/98 May 04, 1998


Gord Dibben Excel MVP