Open Menu
Close Menu
Apple
Shopping Bag
Apple
Mac
iPad
iPhone
Watch
TV
Music
Support
Search apple.com
Shopping Bag
Lists
Open Menu
Close Menu
Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists
Excel format cels as number with Applescript
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Excel format cels as number with Applescript
Subject
:
Excel format cels as number with Applescript
From: Bert Groeneveld <
email@hidden
>
Date: Sun, 28 Jun 2009 22:50:35 +0200
Hello, can anyone poste Applescript example code for the following:
While talking to the active document of Microsoft Excel 2004:
I want to refer to the column whose first cel contains exactly the text "Article number"
I want to format all the cels of that single column as Number with zero decimal places.
(cel 2 of that column for example reads "8,08191E+13" and I want it to be in the normal number format so that it reads "80819094600000")
That's all I want. Can anyone help please?
Kind regards, Bertus.
_______________________________________________
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
Follow-Ups
:
Re: Excel format cels as number with Applescript
From:
Paul Berkowitz <email@hidden>
Prev by Date:
Re: (no subject)
Next by Date:
Scripting an Applescript studio application
Previous by thread:
Re: Telling remote Finder to sleep
Next by thread:
Re: Excel format cels as number with Applescript
Index(es):
Date
Thread