Tex-to-column

[Rickster]

In Excel 2003...The delimiter is a comma...However, one of the numbers is
above $1,000 and the number includes a comma (1,000 rather that 1000), so
Excel creates another column. Is there a way to get around this?

 

[Homey]

only way is quotes marks. like "1,000",500,5 how else can excel know which
comma is delimter?

| In Excel 2003...The delimiter is a comma...However, one of the numbers is
| above $1,000 and the number includes a comma (1,000 rather that 1000), so
| Excel creates another column. Is there a way to get around this?
|
|

 

[Rickster]

only way is quotes marks. like "1,000",500,5 how else can excel know which
comma is delimter?

| In Excel 2003...The delimiter is a comma...However, one of the numbers is
| above $1,000 and the number includes a comma (1,000 rather that 1000), so
| Excel creates another column. Is there a way to get around this?
|
|

.

Thanks for the reply, Homey. However, the number has dittos around it, so
I'm wondering if there is another way?

 

[Rickster]

Thanks for the reply, Homey. However, the number has the quotation marks
around it already...