Date format

  • Thread starter Jean-Francois Boucher
  • Start date
J

Jean-Francois Boucher

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?
 
A

al9315

Jean-Francois Boucher said:
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?
Click to expand...

=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
 
G

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
 
Top