No, it stills comes up as dddd...it's very strange as I have tried DATEDIF functions with the same worksheet and they work fine. It's only the =TEXT that doesn't.

Thanks for your help anyway.