Posted to microsoft.public.excel.misc

Wackyracer Wackyracer is offline

external usenet poster

Posts: 9

reformat cells for date

I have a csv file that contains a column with dates in it. Unfortunately the
column has the information entered as DMMYY for 5/12/08 or DDMMYY for
20/12/08. So for days 1st to 9th there is no 0 at the front end.

I need to be able to change this coloumn so it reads DD/MM/YYYY so I can
import it into another programme. Can any help?

Many thanks

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
how to reformat numbers	C.Loner	Excel Discussion (Misc queries)	4	January 23rd 08 12:31 AM
Reformat numbers	EllenM	Excel Discussion (Misc queries)	6	August 8th 07 04:22 PM
Reformat spreadsheet	JoP	Excel Worksheet Functions	1	July 5th 07 06:09 PM
Reformat Table	[email protected]	Excel Discussion (Misc queries)	4	December 23rd 06 09:50 AM
How to Stop Reformat When Cells Are Copied	Strong Eagle	Excel Discussion (Misc queries)	1	April 30th 06 02:42 AM

All times are GMT +1. The time now is 12:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us