decimal formatting issues

100159x…….4
019950x…….…4
100014x…….…4
620004x……..1
620010x……...…2
100000x……...…5

Hi guys/girls I have a weird issue. my excel seems to be grouping decimals into threes or ones randomly(see above examples). So what i am doing is pasting from Autocad lists that look like the above and then my spreadsheet separates the article number from the quantity then maps out the proper number that is meant to be inserted into a software program i made. Which would look like this below, same format but different numbers

220010x........5

however for some reason my Excel is now grouping the decimals strangely and my sql database doesnt recognize them as a VARCHAR. is there a solution to this?

bcount converter.xlsxi don,t know if that worked i've never uploaded a post to this site before. but if you go to sheet one and select any of the cells that are yellow you will see that the decimals are gouped in threes. In the formula to the left i just created it with

Formula:

Please Login or Register  to view this content.

Thanks that was it

Originally Posted by MrShorty

My debugging steps:

1) Use LEN() function on yellow cell to count characters -- there appeared to be too few characters.
2) Delete cell references from G2 to get only the decimals without the concatenation. =LEN() still suggests too few characters
3) Use =CODE() function to determine exactly which character is the last character in G2 -- get code 133
4) enter a single "." in a cell and use =CODE() function to get character code for a period -- got 46. "." characters in G2 are not the same as a period
5) Go to windows character map tool and try to figure out what character is a code 133. It looks like your formula is using the "ellipsis" character rather than the dot (.) character.

Not sure why -- whether the dots were originally entered as ellipses or if Excel automatically substituted an ellipsis character for three dots (check autocorrect options).