Use 'string value of cell...' instead of just 'value of cell...' if
you want a string instead of a number.
On Wed, Nov 18, 2009 at 11:15 AM, Bill Steele <[log in to unmask]> wrote:
> I have an Excel spreadsheet with e-mail addresses: column A is the user,
> column B is the domain. I need to concatenate them. Problem arises when I
> hit a compuserve address:
>
> set addLeft to value of cell 1 of row i of used range of
> active sheet
> set addRight to value of cell 2 of row i of used range of
> active sheet
> display dialog addLeft --> 12345.6789
> display dialog (addLeft & "@" & addRight) as string -->
> [log in to unmask]
>
> Applescript treats the number as floating point when converting it to a
> string???
>
> The column in Excel is formatted as string.
>
> --
>
> Bill Steele
> [log in to unmask]
>
--
Mark J. Reed <[log in to unmask]>