Re: Excel Making String into Number
Re: Excel Making String into Number
- Subject: Re: Excel Making String into Number
- From: Hans Haesler <email@hidden>
- Date: Sun, 4 Feb 2001 22:02:27 +0100
On Fri, 2 Feb 2001, David Silverman wrote:
>
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.
Hello David,
this works for me, even when the cell is formatted 'as number':
---
tell application "Microsoft Excel"
tell Worksheet 1
set aVal to text of Cell "L1C1"
end tell
end tell
-->"9999999999"
Regards,
Hans
---
Hans Haesler | email@hidden