View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna Anna is offline
external usenet poster
 
Posts: 132
Default Delimiting when seperator is a comma & number is bigger than 1,000

I have a data download that is appearing in the column like this:

1021,105,1268

I am trying to delimit it to appear in 3 seperate columns like this:

1021 105 1268

But excel is reading the , as a thousand seperator & therefore treating the
cell as a whole number ie 10211051268

Is there any way I can overwrite this, or another way I can seperate into
columns? The reason I need to is to do a vlookup on another sheet as the
above refer to product codes & I need to report on total sales for all
products.

Any help gratefully appreciated!!

Anna