Tex-to-column

R

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?
 
H

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?
|
|
 
R

Rickster

Homey said:
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?
|
|

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

Rickster

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