Problems with date formats

[ridsey]

Hi,

I have 5000 rows of information that has a column with dates entered in it. The dates have been entred in the format 990920. I want to be able to convert them to the format of 09/20/1999. I understand the @DATE command, and used it to convert the date to an integer, then convert the integer to the desired date. But how can i use the @DATE command on all rows, so i dont have to go through each row individually. Is there a pre-built function i can use, or a macro that can be used to transfer all the dates to the new format.

thank you

Ridsey

 

[crazybird]

If your date is a number in A1, try this:

@DATE(@TRUNC(A1,-4)/10000+@IF(A1<=90000,100,0),@TRUNC(@MOD(A1,10000),-2)/100,@MOD(A1,100))

 

[ridsey]

Thank you for your help,

Im not that familiar with lotus123, so this may sound stupid, but do i put this in the top row and copy downwards, or do i need to put this code somewhere else? I guess i'm just wondering if this will convert all 5000 rows i have at once.

Thanks again

Ridsey

 

[ridsey]

dont worry about it, i got it workin, just a stupid mistake on my part!

thanks very much for the help!

ridsey