• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Excel Making String into Number
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


References: 
 >Excel Making String into Number (From: "David Silverman" <email@hidden>)

  • Prev by Date: Excel Making String into Number
  • Next by Date: Re: Excel Making String into Number
  • Previous by thread: Excel Making String into Number
  • Next by thread: Re: Excel Making String into Number
  • Index(es):
    • Date
    • Thread