Re: Excel Making String into Number
Re: Excel Making String into Number
- Subject: Re: Excel Making String into Number
- From: Shane Stanley <email@hidden>
- Date: Mon, 05 Feb 2001 08:02:32 +1100
On 3/2/01 7:13 AM +1000, David Silverman, email@hidden, wrote:
>
Hi, I've been trying to write my first applescript. It's goal is to take
>
numbers from an Excel spreadsheet and then put them in an application that
>
makes a bar code out of them.
>
>
Problem, the numbers are 10 digits long like 999999999. However, even when I
>
set the properties of the Excel cell to "text" applescript insists as
>
reading them as real numbers and not as strings. Then, when I coerce into a
>
string I get "9.99999999E+9" or something like that.
If you ask for the text of a cell or range, you should get the format you
want. Try this:
tell application "Microsoft Excel"
tell Worksheet 1
text of Range "R1C1"
end tell
end tell
--
Shane Stanley, email@hidden