Posted to microsoft.public.excel.misc

pol

external usenet poster

Posts: 129

date format problem

When I am opening dbf file in excel 2007 , some date is showing as
04/01/2009
04/01/2009
20090423
20090425

So how I can convert all the date into same format 'dd/mm/yyyy' format
Please let me know

With Regards
Pol

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
Date Format Problem	Maperalia	Excel Worksheet Functions	3	January 23rd 09 05:25 PM
Date Format Problem	Suzanne	Excel Discussion (Misc queries)	2	February 20th 08 03:05 PM
date format problem??	Steve[_9_]	Excel Discussion (Misc queries)	10	December 27th 07 11:23 PM
Date format problem	Natalie	Excel Worksheet Functions	4	June 7th 07 01:28 PM
Date format problem	Vass	Excel Worksheet Functions	7	April 3rd 06 04:50 PM

All times are GMT +1. The time now is 02:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us