I'm using a web query in excel so I can't put a comma or a space infront of the text to stop it autoformatting to date format. I've tried checking the box preserve formatting in the web query options box but it seems to ignore this and automatically convert anything it can into a date format.