Format cells via AppleScript

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Costin Miron - 24 Apr 2005 16:37 GMT

I'm looking for a way to format a cell range (let's say {A1:B6}) as number
without decimals (integer number) via AppleScript.

Anybody can help me?

Reply to this Message

Paul Berkowitz - 24 Apr 2005 17:14 GMT

On 4/24/05 8:37 AM, in article BE913564.548%costin-m@sympatico.ca, "Costin
Miron" <costin-m@sympatico.ca> wrote:

> I'm looking for a way to format a cell range (let's say {A1:B6}) as number
> without decimals (integer number) via AppleScript.
>
> Anybody can help me?

tell application "Microsoft Excel"
set number format of range "A1:B6" to "0"
end tell

-- in Excel 2004 : you didn't say which version.

Signature

Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

Reply to this Message

Costicla Dop - 24 Apr 2005 17:29 GMT

Thanks a lot, Paul!

I am using Office 2004, sorry for not mentioning.

On 4/24/05 12:14 PM, in article BE911404.94169%berkowit@spoof_silcom.com,

> On 4/24/05 8:37 AM, in article BE913564.548%costin-m@sympatico.ca, "Costin
> Miron" <costin-m@sympatico.ca> wrote:
[quoted text clipped - 9 lines]
>
> -- in Excel 2004 : you didn't say which version.

Reply to this Message

Mac Forum / Applications / Excel / April 2005

Format cells via AppleScript