If u precede the data with an apostrophe then Excel will not try to autoformat it.
At 03:35 PM 12/15/2005 -0800, Glen Plantz wrote: >I want to force the contents of a Cell that has a DATE value ( "Dec >2005" ) to be a string. >What happens is the Date value 'DEC 2005' in converted into 'Dec-05'. $formatteddate = "'DEC 2005"; -- REMEMBER THE WORLD TRADE CENTER ---=< WTC 911 >=-- "...ne cede malis" 00000100 _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs