How do I stop Excel from turning November 2006 into Nov-06?
 

Excel is driving me mad. How can I permanently turn off the function which
converts dates entered as November 2006 to Nov-06?

How do I stop Excel from turning November 2006 into Nov-06?
 

Format column as mmmm aaaa

HTH
--
AP

"Jessamine" a écrit dans le message de
news: ...
Excel is driving me mad. How can I permanently turn off the function
which
converts dates entered as November 2006 to Nov-06?

How do I stop Excel from turning November 2006 into Nov-06?
 

Select the cell - Format- cells-date and then choose whatever you
like.
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=544803