Posted to microsoft.public.excel.misc

noel

Posts: n/a

convert date format

i am using microsoft office 2003.
currently i need to columns of data (in general format) to date (DD/MM/YY)
format.
tried clicking Format=Cells=Number=Date (select date type) it doesnt work.

please advise alternate method thanks.

regards
noel

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode 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
Convert Date Format	Mike	Excel Discussion (Misc queries)	2	November 6th 05 12:27 AM
Date Format Squirrelly	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	2	August 19th 05 10:49 AM
Conditonal Format with a date format	Kevin	Excel Discussion (Misc queries)	2	April 27th 05 10:20 PM
How to convert string to a date	galsaba	Excel Worksheet Functions	3	March 4th 05 05:20 PM
Date Format Question	Josh O.	Excel Discussion (Misc queries)	1	February 10th 05 09:45 PM

All times are GMT +1. The time now is 03:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us