double click a cell with Date format

Posted to microsoft.public.excel.misc

qqxz

Posts: n/a

double click a cell with Date format

Dear All,

I have a column in this Excel defined as Date format, "dd-MMM-yy"
type.
However, when I open the file, some cells have value like
"20/11/2005".
After I double-clicked the cell, it would change to "20-Nov-05".

Anyone could advise what "double click" triggered in this case? How
to
change all the values in the column simultaneously?

Thanks.

--
qqxz
------------------------------------------------------------------------
qqxz's Profile: http://www.excelforum.com/member.php...o&userid=30773
View this thread: http://www.excelforum.com/showthread...hreadid=504421

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 format cell with text and date.	Darlene Niebruegge	Excel Discussion (Misc queries)	4	September 29th 05 02:30 PM
How do I double click a cell and jump to cell's referenced cell	JerryJuice	Excel Discussion (Misc queries)	2	September 10th 05 10:24 PM
Imported Date & Time format with calcs. managed in excel from imrp	Todd F.	Excel Worksheet Functions	0	July 8th 05 09:03 PM
date format within a cell containing a formula	Brushie76	Excel Discussion (Misc queries)	1	January 22nd 05 03:50 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM

All times are GMT +1. The time now is 05:14 PM.

Menu

About Us