MACSCRPT Archives

November 2009

MACSCRPT@LISTSERV.DARTMOUTH.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: float numbers as strings
From:
"Mark J. Reed" <[log in to unmask]>
Reply To:
Macintosh Scripting Systems <[log in to unmask]>
Date:
Wed, 18 Nov 2009 11:46:38 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (32 lines) 
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]>

ATOM RSS1 RSS2