Posted to microsoft.public.excel.misc

Robin Gray Robin Gray is offline

external usenet poster

Posts: 2

Date Formatting

I have a csv file which when opened with excel shows dates as 15041978 or
4051949. I am struggling to convert these to the normal format 15/04/1978
or 04/05/1949.
Any suggestions.

TIA

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 for cell date to equal today's date	Sistereinstein	Excel Worksheet Functions	2	September 10th 12 07:53 PM
Date Formatting	theresa317	Excel Worksheet Functions	3	April 17th 08 12:07 AM
Formatting as date	gwplotts via OfficeKB.com	Excel Worksheet Functions	3	April 17th 07 03:09 PM
Date formatting	Melissa	Excel Discussion (Misc queries)	2	November 9th 06 05:37 PM
Help with formatting the date.	Lee	Excel Discussion (Misc queries)	6	February 24th 06 07:27 PM

All times are GMT +1. The time now is 02:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us