Format cells via AppleScript

[Costin Miron]

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?

 

[Paul Berkowitz]

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.


--
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.

 

[Costicla Dop]

Thanks a lot, Paul!

I am using Office 2004, sorry for not mentioning.