I am working with file uploads from Excel via TXT tab delimited files.

The data in the excel is copied and pasted special/values so there are no
formulas.
(obviously!)

In the TXT file, numbers that are more than 3 places for example 1,000.00
(it as the comma in the excel format) show up as "1,000.00" (with the
quotation marks).

This is a problem because my file upload reads that as a set of characters,
not as a number.

Is there anyway to get those larger numbers to convert without the quotation
marks?

I am just using FILE/SAVE AS and using the drop down window to select Text
File/tab delimited, but perhaps there is some other step where I can make
more selections about how the data is saved?

thanks!




I'm using Excel 2003 / SP3

Sorry - long day - no response needed - I've worked it out!

"LinLin" wrote:

I am working with file uploads from Excel via TXT tab delimited files.

The data in the excel is copied and pasted special/values so there are no
formulas.
(obviously!)

In the TXT file, numbers that are more than 3 places for example 1,000.00
(it as the comma in the excel format) show up as "1,000.00" (with the
quotation marks).

This is a problem because my file upload reads that as a set of characters,
not as a number.

Is there anyway to get those larger numbers to convert without the quotation
marks?

I am just using FILE/SAVE AS and using the drop down window to select Text
File/tab delimited, but perhaps there is some other step where I can make
more selections about how the data is saved?

thanks!




I'm using Excel 2003 / SP3