excel cell/bar ip addressing missing dots

[milanoke]

hi, i am using excel for database of my ip plan, some dot are missing for copy/paste. it looks like present 13 character. Someone know about this issue ?
10.190.127.98 (cell) --> 10.190.127.98 (bar)
10.190.127.99 (cell) --> 10.190.127.99 (bar)
10.190.127.100 (cell) --> 10190127100 (bar)
10.190.127.100 (cell) --> 10190127101 (bar) and more till end
10.190.127.255 (cell) --> 10190127255 (bar)
10.190.128.1 (cell) --> 10.190.128.1 (bar)

 

[Legacy 143009]

Yess.. Excel recognized them as numbers and dots as thousand separators. So now it is threading them normal intiger numbers.
What you can do is either select cell format as text or add ' at the beginning of values:'10.190.127.100