I used to live in the land of zero-leading zip codes (NJ, PA),= so treating numbers as text in Excel was important to keep the leading zero = from being dropped.
You = can use Excel's File --> Import for your data and specify any field to b= e text, and that will work. Thereafter, that column will accept your data= as text if pasted in.
Terry
On Tue, 10 Jan 2012 12:18:36 -0600
Eddie Z <eddie@thinksite.com&= gt; wrote:
Ok, since the Excel subject came up today, I started looking i= nto it
for the
first time in years. Turns out Excel can't open numbers over 15
characters.
You can trick Excel into thinking the= number is text by wrapping it
in
quotes or putting a non-numeric= al character in front of it.
So now I have two options:
Make su= re the cart number is 15 characters or less, or I place a
random
letter in front of all of my cart numbers. I don't care for the
quote= s idea.
Can the [cart] variable be altered to 15 characters or l= ess? I assume
I
could do it with [getchars], but I'm not sure if it wo= uld still
remain
unique.
Is there a downfall to having a letter in front of my cart number,
like
R162389472337495033? The = only thing I can think of is that it may
effect
some [math] code.=
On 1/10/12 12:00 PM, "Eddie Zelhofer" <eddie@thinksite.com&g= t; wrote:
> I've tried everything, but I'm not an expert Excel user by any means.
>If I
> open in Excel a cart number looks= like this: 1.06391E+16 instead of
> 10639064155219361. If I change= the formatting on the cell, the
>closest I can
> get to the actu= al cart number is 10639064155219300. The first 15
>characters
&= gt; are correct, but it goes to zeros after that. So unless there's some
= >sort of
> setting that can be done before I open the file, I do= n't know how
>this is
> possible.
>
> This really w= ould come in handy for me if anyone out there knows how
>I could
> get around this issue.
>
> Eddie
>
&= gt;
> On 1/10/12 11:33 AM, "Donovan Brooke" <dbrooke@euca.us>= ; wrote:
>
>> Eddie Z wrote:
>>> I only use a t= ext editor (BBEdit) for my dbs. I've never figured out
>>>ho= w to
>>> keep Excel from truncating my [cart] numbers when open= ing a db text
>>>file for
>>> the first time tho= ugh. If there's a secret to that I'd like to know
>>>it.
>&= gt;>
>>> Eddie
>>
>> It's a preference setting on the column. (format cell if remember
>>right)
>= ;>
>> Donovan
>>
>
>
> ---------------------------------------------------------
> This me= ssage is sent to you because you are subscribed to
> the mailing li= st <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave= @webdna.us>
> archives: http://mail.webdna.us/list/talk@webdna.us
> Bug Reporting: support@= webdna.us
-------------------------------------------------= --------
This message is sent to you because you are subscribed to
the mailing= list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/tal= k@webdna.us
Bug Reporting: support@webdna.us
I used to live in the land of zero-leading zip codes (NJ, PA),= so treating numbers as text in Excel was important to keep the leading zero = from being dropped.
You = can use Excel's File --> Import for your data and specify any field to b= e text, and that will work. Thereafter, that column will accept your data= as text if pasted in.
Terry
On Tue, 10 Jan 2012 12:18:36 -0600
Eddie Z <eddie@thinksite.com&= gt; wrote:
Ok, since the Excel subject came up today, I started looking i= nto it
for the
first time in years. Turns out Excel can't open numbers over 15
characters.
You can trick Excel into thinking the= number is text by wrapping it
in
quotes or putting a non-numeric= al character in front of it.
So now I have two options:
Make su= re the cart number is 15 characters or less, or I place a
random
letter in front of all of my cart numbers. I don't care for the
quote= s idea.
Can the [cart] variable be altered to 15 characters or l= ess? I assume
I
could do it with [getchars], but I'm not sure if it wo= uld still
remain
unique.
Is there a downfall to having a letter in front of my cart number,
like
R162389472337495033? The = only thing I can think of is that it may
effect
some [math] code.=
On 1/10/12 12:00 PM, "Eddie Zelhofer" <eddie@thinksite.com&g= t; wrote:
> I've tried everything, but I'm not an expert Excel user by any means.
>If I
> open in Excel a cart number looks= like this: 1.06391E+16 instead of
> 10639064155219361. If I change= the formatting on the cell, the
>closest I can
> get to the actu= al cart number is 10639064155219300. The first 15
>characters
&= gt; are correct, but it goes to zeros after that. So unless there's some
= >sort of
> setting that can be done before I open the file, I do= n't know how
>this is
> possible.
>
> This really w= ould come in handy for me if anyone out there knows how
>I could
> get around this issue.
>
> Eddie
>
&= gt;
> On 1/10/12 11:33 AM, "Donovan Brooke" <dbrooke@euca.us>= ; wrote:
>
>> Eddie Z wrote:
>>> I only use a t= ext editor (BBEdit) for my dbs. I've never figured out
>>>ho= w to
>>> keep Excel from truncating my [cart] numbers when open= ing a db text
>>>file for
>>> the first time tho= ugh. If there's a secret to that I'd like to know
>>>it.
>&= gt;>
>>> Eddie
>>
>> It's a preference setting on the column. (format cell if remember
>>right)
>= ;>
>> Donovan
>>
>
>
> ---------------------------------------------------------
> This me= ssage is sent to you because you are subscribed to
> the mailing li= st <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave= @webdna.us>
> archives: http://mail.webdna.us/list/talk@webdna.us
> Bug Reporting: support@= webdna.us
-------------------------------------------------= --------
This message is sent to you because you are subscribed to
the mailing= list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/tal= k@webdna.us
Bug Reporting: support@webdna.us
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...