0

When I insert a txt file with numbers such as 185567.21 the result is 185.567.21. It keeps disturbing my numbers and I cannot work.

Any solutions to stop this?

Improve this question
5
  • Are they truly numbers? Or just strings resembling numbers?
    – Envite
    Mar 8, 2017 at 12:04
  • Control Panel > Region and Language > Formats > Advanced. Change Digit Grouping to 123456789
    – DavidPostill ♦
    Mar 8, 2017 at 12:04
  • Hi David, thank you for your time to address to my problem. There are coordinates where the txt file contains easting northing . When i insert them in notepad it is ok but when I insert them in excel the numbers from 205567.89 changes to 205.567.89
    – Chrysostomos Georgiou
    Mar 8, 2017 at 12:15
  • Excel is seeing the values as a number, and changing it to Excel's default number format (varies depending on your Windows regional settings). To retain the original format, you can import the values as Text. If the text file has a file extension of .txt, then the text import wizard should open when you open the file, and you can designate that column as text. If that is not happening, you may need to "reset" the wizard. If it is .csv, you will need a different process.
    – Ron Rosenfeld
    Mar 8, 2017 at 20:28
  • 1
    It is impossible for "205.567.89" to be a number. You can not have a dot being at the same time decimal separator and thousands separator. Hence my first comment. Check if there are any comma.
    – Envite
    Mar 10, 2017 at 9:55

1 Answer 1

Reset to default
0

Changing the default formatting for Number fields will sort this out.

For temporary solution, highlight, format and change the numbers format. For a permanent solution, you will need to look in settings to ignore decimal markers for 1000s

Improve this answer
2
  • Hi HoNoR, Thank you for taking time to address. When I do change the default formatting for number fields then the 185.567.21 becomes 18556721. That means I loose the 2 decimals. The number should be 185567.21.
    – Chrysostomos Georgiou
    Mar 8, 2017 at 12:39
  • Is the 'Use 1000 seperator' box ticked? If all else fails, format the row/column as text and it will copy in as is.
    – Quantum714
    Mar 9, 2017 at 13:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .