try modify yr formula to:

=Date(Right(A1,4),Left(A1,2),mid(A1,3,2))

HIH

On 16 Paź, 14:50, jlclyde wrote:
In the AS400 it stores date as monthdayyear and does not seperate
them. Â*So when it spits it out into excel this is what you get.
10012000. Â*So the date shoudl be October first 2000. Â*When I use this
formula if 1001200 was in cell A1 it woudl be =Date(Right(Year(A1),
4),Month(Left(A1,2)),Day(Right(Left(A1,4),2))) Â*It returns the date
10-1-1905. Â*Is this a bug or did I do something wrong? Â*I have tried
using value and Int to straighten it out with no luck.

Thanks,
Jay