Excel Making String into Number
Excel Making String into Number
- Subject: Excel Making String into Number
- From: "David Silverman" <email@hidden>
- Date: Fri, 2 Feb 2001 15:13:00 -0500
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.
I am going to resort to editing the string so two questions:
- what's the best way to edit the string.
- is there a better way?
david
email@hidden