Mike Busch

Posts: n/a

Dat Formatting

I received a large ASCII format document that I imported into Excel. The date
appears as 19500323. Is there anyway to format this to read 03/23/1950.
thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Conditional Formatting in Excel Help Please.....	Willie T	Excel Discussion (Misc queries)	4	February 9th 05 02:28 PM
Formatting dates in the future	Compass Rose	Excel Worksheet Functions	3	January 17th 05 10:39 PM
Copy conditional formatting across multiple rows?	Gil	Excel Discussion (Misc queries)	1	January 11th 05 11:27 AM
Conditional formatting not available in Excel	BAB	Excel Discussion (Misc queries)	2	January 1st 05 03:33 PM
How do I use conditional formatting for multiple rows?	Jim Johnson	Excel Worksheet Functions	1	October 30th 04 03:36 AM

All times are GMT +1. The time now is 06:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us