The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum. |
excel column format |
Post Reply |
Author | |
jtillia
Beta Tester Joined: August 03 2004 Location: United States Status: Offline Points: 67 |
Post Options
Thanks(0)
Posted: January 20 2006 at 2:31am |
Is there a way to force a column to text during a download to excel.
We commonly use the bridge to convert information, but this process need be run from a phantom in our night-time-processor. We have a column of part numbers. These are leters and/or numbers. The numbers may have decimals in them. The download process will try to format these as "numbers" including doing the decimal conversion. I need the column to be text all the time. I have put the "'" (single quote char(39)) in front of the value before I dump it down. This works, except excel leaves this in the resulting value. SO, this does not work like typing it in Excel. Any ideas ? I can't really open the excel sheet during the process. |
|
jtillia
Beta Tester Joined: August 03 2004 Location: United States Status: Offline Points: 67 |
Post Options
Thanks(0)
|
By the way, we also want a part number to show up as
0000123456 and not 123456 |
|
jtillia
Beta Tester Joined: August 03 2004 Location: United States Status: Offline Points: 67 |
Post Options
Thanks(0)
|
we have found one way to do this. The data that we move down looks like:
rec<-1> = '=UPPER("':part.nbr:'")' I guess because we call a "text" function the the value, it then considers it a "text" string. This also appears to work fine, if you do a "save as" from excel to a TXT file (tab delimetted). We move our files around and use the data in other systems. |
|
jgold
Moderator Group Moderator Joined: December 29 2003 Location: United States Status: Offline Points: 48 |
Post Options
Thanks(0)
|
In Excel you can format a cell or an entire column as text. Formatting it as text keeps Excel from trying to convert the value to a number. All you would need to do is create a blank worksheet with the column formatted as text then load the data into it like normal.
|
|
Mike Gross
Beta Tester Joined: January 20 2004 Location: United States Status: Offline Points: 41 |
Post Options
Thanks(0)
|
Jessie or Anyone,
On this same subject we are sending data to EXCEL using FTD. Do you know of a way to format the cell of each field based on the data. For example, if the data is MR2 in pick we could fromat the cell as currency and right justified. Now the user receives the data and must format the cell in Excel by highlighting the cell, right click on format cell ect. ect.. Thanks Mike |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |