Ellipsis/Three dots/(...) in Excel
In Excel when we write three dots/Ellipsis/(...) then this changes into a special character called ellipsis with the code 0133.
That means if we will write three back to back dots in Excel it will change into a single character. So when we will try to read this will not give us three dots and may create problem for us, suppose if I am reading data from Excel through some scripts/programs then it can cause problem as it created in my case.
So if don't want this to happen, then we can stop this. Use the following:-
In Excel 2010
1. File >> Options
2.Then in the Excel Options window click AutoCorrect Options
3. Then in the dialog opened you will find a table. This contains predefined values that some value to be replaced by another. Here search three dots(...) entry and delete it. In this table it is defined that Excel must replace the three dots into a single character called ellipse.
We can do this in same way in Excel 2003/7 by through the Tools menu.
This problem also occurs in Word and we can solve it in the similar way.