Excel Cell Format Question
Excel Cell Format Question
- Subject: Excel Cell Format Question
- From: Oakley Masten <email@hidden>
- Date: Fri, 30 May 2008 10:50:50 -0700 (PDT)
Hi All
I need to set the format of cells in an excel doc that
I am creating using AppleScript.
The cells appear to automatically come up as formatted
"General"
I think I need to set the format to "Text".
What I need to do is to take a value from row 3 column
2 modify it and put it in the next column
ie row 3 column 2 might be "11942"
I want to change it to < AR11942> and put it in
row 3 column 3.
I tried:
tell application "Microsoft Excel"
activate
tell active sheet
set value of cell 2 of column 12 to ("<AR" & ((value
of cell 2 of column 5) as text) & ">")
end tell
When I try it I got <AR1.1942E+4>
How can I fix this?
I have looked in everyl Scripting book I own and the
MacTech scripting pdf and have found nothing that
helps.
Thanks
Oakley
_______________________________________________
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