"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