Posted to microsoft.public.excel.misc

Richard Roche

Posts: n/a

XML Date formatting

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with formatting the date.	Lee	Excel Discussion (Misc queries)	6	February 24th 06 07:27 PM
formatting a cell to display the correct date.	Lee	Excel Discussion (Misc queries)	1	February 23rd 06 04:04 PM
Can a date be used for conditional formatting?	Stevie P	Excel Worksheet Functions	2	September 27th 05 09:42 PM
Conditional Formatting, date.	DissentChick	Excel Worksheet Functions	2	July 20th 05 03:37 PM
Despite formatting a column in Excel 2002 worksheet as Short Date.	Pete Whalley	Excel Discussion (Misc queries)	2	February 7th 05 06:17 PM

All times are GMT +1. The time now is 05:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us