Re: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108052
interpreted = N
texte = 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 actual cart number is 10639064155219300. The first 15 characters 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 don't know how this is possible. This really would come in handy for me if anyone out there knows how I could get around this issue. Eddie On 1/10/12 11:33 AM, "Donovan Brooke"
wrote: > Eddie Z wrote: >> I only use a text editor (BBEdit) for my dbs. I've never figured out how to >> keep Excel from truncating my [cart] numbers when opening a db text file for >> the first time though. If there's a secret to that I'd like to know it. >> >> Eddie > > It's a preference setting on the column. (format cell if remember right) > > Donovan >
Associated Messages, from the most recent to the oldest:
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 actual cart number is 10639064155219300. The first 15 characters 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 don't know how this is possible. This really would come in handy for me if anyone out there knows how I could get around this issue. Eddie On 1/10/12 11:33 AM, "Donovan Brooke" wrote: > Eddie Z wrote: >> I only use a text editor (BBEdit) for my dbs. I've never figured out how to >> keep Excel from truncating my [cart] numbers when opening a db text file for >> the first time though. If there's a secret to that I'd like to know it. >> >> Eddie > > It's a preference setting on the column. (format cell if remember right) > > Donovan >
Eddie Z
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
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...
Related Readings:
weirdness in the error log (1998)
FEW QUESTIONS (1997)
Exclamation point (1997)
Multiple cart additions (1997)
WebDNA / Red Hat 9 ? (2003)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
Need help with emailer- 2 issues (1997)
[WebDNA] OSX users (2009)
email [title] (1997)
Bulk Processing Offline (2004)
Multiple Replaces (1997)
RE: Help name our technology! (1997)
Setting up shop (1997)
Price recalc based on quantity (1997)
OT: Conditional Redirect (2004)
Running _every_ page through WebCat ? (1997)
[group] ? (1997)
Auction (2000)
Cookies (1999)
Confused about QTY and QTY* price updating (1998)