PS - you can also use [Format][cell][Number tab] and select custom. Then
specify mmm this will allow excel to treat it as a numeric
quantity, and still have it be presented as you wish.
Glen Plantz wrote:
Hi Folks,
I'm having trouble formatting the Cell Contents of an Excel sheet with
You can probably accomplish what you want by doing [Format][Cell][Number
tab] and selecting text.
Excel likes to infer that cells are dates because then it can treat them
as an ordered list, and you can do arithmetic like this day next week =
today + 7. Under [Format][Cell][Number tab] the date
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'.
Title: Message
Hi
Folks,
I'm having trouble
formatting the Cell Contents of an Excel sheet with
Win32::OLE.
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'.
Any help will be
Try something like this:
$Sheet1-Range(D2)-{NumberFormat} = MMM ;
and please use plain text instead of HTML for mailing list traffic. :)
Cheers,
-Jan
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: