Hi
try this

=LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&RIGHT(A1,4)

Regards
Matt




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

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200910/1