millennium.atrex
Nothing major....just a *stupid* question
Thread Starter: Todd Patterson Started: 8/12/2010 1:00 AM UTC
Replies: 4
8/12/2010 1:00 AM UTC
Nothing major....just a *stupid* question
Reply Quote Delete

Todd Patterson

This has absolutely nothing to do with Atrex :)

When exporting inventory and opening that file in Excel do you guys know of a way to have excel recognize longer numbers, like UPS codes?  Each time I try to remember to change the individual columns but usually forget so I end up with weird stuff in the model field, like 6.56E+11 or funky stuff like that.

Not all of the fields in that column contain numbers that are that long, as some of them are alphanumeric as well.  Just a question.......

BTW....thanks for the push on the db routine.  Seems to work just fine!  How did you do in the run?

Todd
8/12/2010 2:35 AM UTC
Re: Nothing major....just a *stupid* question
Reply Quote Delete

Terry Swiers

Todd,

When exporting inventory and opening that file in Excel do you guys know of a way to have excel recognize longer numbers, like UPS codes?  Each time I try to remember to change the individual columns but usually forget so I end  up with weird stuff in the model field, like 6.56E+11 or funky stuff like that.

I unfortunately don't know enough about Excel to answer this one.  I do know that the exports have an option to auto-format the fields.  If that option is checked, it will set the cell type to being a number if the value type in the report is a number.


BTW....thanks for the push on the db routine.  Seems to work just fine!

No troubles.


How did you do in the run?

Cranked out 18.6 miles in 2:34.  Was hoping for a flat 2:30, but it just wasn't an "on" day.

--  

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

Now shipping Atrex 13.  For more information go to
 http://www.atrex.com/news.asp

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 --------------------------------------- w
8/12/2010 3:06 PM UTC
Re: Nothing major....just a *stupid* question
Reply Quote Delete

Todd Patterson

Terry -

I unfortunately don't know enough about Excel to answer this one.  I do know that the exports have an option to auto-format the fields.  If that option is checked, it will set the cell type to being a number if the value type in the report is a number.

Same here...congrats on the timing though --- I would have died of massive stroke or something ;-)
8/25/2010 6:31 PM UTC
Re: Nothing major....just a *stupid* question
Reply Quote Delete

John Lange

I don't know if you can set it to happen automatically, but when you import into Excel, one of the steps allows you to set the format for a particular column.

I set the UPC column to TEXT and it parses properly.

JOhn ><>
8/25/2010 8:49 PM UTC
Re: Nothing major....just a *stupid* question
Reply Quote Delete

Terry Swiers

John,

I don't know if you can set it to happen automatically, but when you import into Excel, one of the steps allows you to set the format for a particular column.  I set the UPC column to TEXT and it parses properly.

You might want to inquire about this in a Excel oriented newsgroup as I don't use Excel enough to know if there is a way to change this.

--  

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

Now shipping Atrex 13.  For more information go to
 http://www.atrex.com/news.asp

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------