Ankur

Posts: n/a

date format

i have a sheet where in some cells the date are in ddmmyy format along with
text & in some cells mmddyy format along with text.

is there any command to change all in mmddyy format

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
Compare dates (one cell not in date format)	craigcsb	Excel Discussion (Misc queries)	5	June 28th 05 05:07 PM
How do I keep the date from changing format in a mail merge?	Brynn Wilson	Excel Discussion (Misc queries)	1	June 9th 05 06:44 PM
Date format	Jean-Francois Boucher	Excel Discussion (Misc queries)	2	February 22nd 05 04:35 PM
USING THE DATE FORMAT IN EXCEL	teach	Excel Discussion (Misc queries)	3	December 14th 04 11:55 PM
Date format collapses diagram	Richard H	Excel Discussion (Misc queries)	3	December 14th 04 11:08 PM

All times are GMT +1. The time now is 12:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us