I have an XML file from ADO.Net when i Import into XL the date is show in the
following format:
2006-04-07T12:11:00.0000000-06:00

XL won't let me format, How can display w/ date formatting?

Thanks
--
Richard