Tex-to-column

  • Thread starter Thread starter Rickster
  • Start date Start date
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?
 
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?
|
|
 
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?
 
Thanks for the reply, Homey. However, the number has the quotation marks
around it already...
 
Back
Top