Coordinate data doesnt show correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-2706940%22%20slang%3D%22en-US%22%3ECoordinate%20data%20doesnt%20show%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2706940%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20with%20the%20format%20of%20my%20excel%20if%20any%20one%20could%20help%20me%20that%20would%20be%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EContext%3C%2FP%3E%3CP%3EWe%20use%20a%20CAD%20program%20to%20generate%20certain%20coordinates%20for%20a%20project.%20the%20CAD%20program%20generates%20a%20text.%20file%20with%20the%20data.%26nbsp%3B%20The%20data%20gets%20imported%20from%20an%20text%20file%20to%20excel%3C%2FP%3E%3CP%3EWhen%20we%20import%20the%20data%20its%20formatted%20as%20text.%26nbsp%3B%20i%20cant%20change%20it%20to%20text%20because%20it%20would%20mess%20up%20the%20presentation%20of%20the%20numbers.%20that's%20why%20i%20cant%20just%20make%20a%20formula%20that%20divided%20by%201000.%26nbsp%3B%20The%20coordinates%20should%20be%20displayed%20as%206%20numbers%20then%20%22.%22%20then%20another%203%20numbers.%20like%20this%20%3A123456.789%3C%2FP%3E%3CP%3Ewhen%20i%20change%20the%20cell%20to%20NUMBER%20i%20get%20a%20number%20like%20this%26nbsp%3B104.159.677.926.%20Is%20it%20possible%20to%20change%20the%20format%20of%20the%20cell%20to%20display%20the%20data%20like%20this%26nbsp%3B123456.789.%20now%20i%20have%20to%20manually%20change%20the%20numbers%20to%20fit%20the%20format%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3EWhen%20i%20import%20the%20data%20from%20text%20it%26nbsp%3B%20show%20up%20like%20this%3A%26nbsp%3B104159677.926%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eand%20it%20should%20be%20like%20this%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E104159.677%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2706940%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi guys,

 

I have a problem with the format of my excel if any one could help me that would be great.

 

Context

We use a CAD program to generate certain coordinates for a project. the CAD program generates a text. file with the data.  The data gets imported from an text file to excel

When we import the data its formatted as text.  i cant change it to text because it would mess up the presentation of the numbers. that's why i cant just make a formula that divided by 1000.  The coordinates should be displayed as 6 numbers then "." then another 3 numbers. like this :123456.789

when i change the cell to NUMBER i get a number like this 104.159.677.926. Is it possible to change the format of the cell to display the data like this 123456.789. now i have to manually change the numbers to fit the format


When i import the data from text it  show up like this: 104159677.926

and it should be like this: 104159.677

 

 

 

 

0 Replies