Re: setting number formats in cells with AS
Re: setting number formats in cells with AS
- Subject: Re: setting number formats in cells with AS
- From: Stan Cleveland <email@hidden>
- Date: Tue, 14 May 2013 11:54:51 -0700
On May 13, 2013, at 3:28 PM, Shane Stanley wrote:
> On 14/05/2013, at 5:34 AM, Stan Cleveland <email@hidden> wrote:
>
>> The rules for defining format strings are not simple, but are relatively easy to understand.
>
> FYI, they're also documented at <http://unicode.org/reports/tr35/tr35-10.html#Number_Format_Patterns>.
> I don't know if Excel implements this fully, but any documentation is better than none.
Hi Shane,
Thanks for sharing the Unicode number format information. I've not taken time yet to do an extensive comparison of Unicode vs. Excel format strings, but a quick looks shows there to be some significant differences.
For example, Unicode uses "@" (at sign) to indicate significant digits, while Excel uses it as a place holder for text.
Also, Unicode supports only two semicolon-delimited subpatterns (for positive and negative numbers), while Excel supports four (for positive and negative numbers, zero, and text).
Regards,
Stan C.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden