Formatting Parse Problem

[anthonyexcel]

I have ton of data In Column A that is looks like 13,165 or 6,300,400,765 the problem is that it is formatted like 13165 and 6300400765 and formatted to a number. I need to parse these numbers based on the commas into separate cells but cannot based on the number format. Can anyone help me with this? Thanks in advance.

 

[FDibbins]

Have you tried Text2Columns?
if the number has no commas (numbers actually wont, only text will allow that), then you have nothing to use for the split.

 

[Scott Huish]

Put a formula next to it like this:
=TEXT(A1,"0,000")

Copy down.
Copy this column and Paste Special Values.
Do a Text to Columns with comma as the delimiter

 

[anthonyexcel]

That's Scott that did it! I appreciate your help!