Unwanted calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-2354402%22%20slang%3D%22en-US%22%3EUnwanted%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354402%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20importing%20data%20from%20a%20program%20called%20Microscribe%20Utility%20Software.%20A%20set%20of%20x%2Cy%2Cz%20coordinates%20are%20recorded%20by%20the%20software%20and%20should%20populate%20cells%20in%20Excel.%20However%20whenever%20there%20is%20a%20coordinate%20in%20the%20negative%20plane%20(a%20value%20with%20a%20%22-%22%20in%20front)%20Excel%20wants%20to%20perform%20a%20calculation%20and%20stops%20recording%20data.%20In%20the%20formula%20tab%2C%20under%20%22Calculate%20options%22%2C%20I%20have%20changed%20it%20to%20manual%20but%20it%20makes%20no%20difference.%20Any%20suggest%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2354402%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2359305%22%20slang%3D%22en-US%22%3ERe%3A%20Unwanted%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2359305%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053796%22%20target%3D%22_blank%22%3E%40Claudia_Meganck%3C%2FA%3E%20%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20know%20your%20problem%2C%20the%20only%20way%20i%20know%20to%20%22solve%22%20this%20problem%20is%20when%20you%20just%20%22enter%22%20into%20the%20next%20cell.%20The%20joke%20is%20now%20you%20can%20just%20use%20one%20column.%20If%20you%20just%20use%20it%20for%20recording%2C%20you%20can%20maybe%20create%20an%20extra%20worksheet%20for%20recording%20the%20coordinates%20and%20use%20late%20vlookup%20to%20import%20into%20a%20better%20worksheet.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20check%20first%20if%20you%20can%20enter%20your%20coordinates%20with%20a%20%22-%22%20and%20press%20%22enter%22%20to%20get%20to%20the%20next%20cell.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3CBR%20%2F%3ESchnittlauch%3CBR%20%2F%3E%3CBR%20%2F%3E%22First%2C%20No%20system%20is%20safe.%20Second%2C%20Aim%20for%20the%20impossible.%20Third%20no%20Backup%2C%20no%20Mercy%22%20-%20Schnittlauch%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20answer%20helped%20you%3F%20Don't%20forget%20to%20leave%20a%20like.%20Also%20mark%20the%20answer%20as%20solved%20when%20your%20problem%20is%20solved.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am importing data from a program called Microscribe Utility Software. A set of x,y,z coordinates are recorded by the software and should populate cells in Excel. However whenever there is a coordinate in the negative plane (a value with a "-" in front) Excel wants to perform a calculation and stops recording data. In the formula tab, under "Calculate options", I have changed it to manual but it makes no difference. Any suggest

1 Reply
Hi @Claudia_Meganck ,

I know your problem, the only way i know to "solve" this problem is when you just "enter" into the next cell. The joke is now you can just use one column. If you just use it for recording, you can maybe create an extra worksheet for recording the coordinates and use late vlookup to import into a better worksheet.

However, check first if you can enter your coordinates with a "-" and press "enter" to get to the next cell.

Best regards,
Schnittlauch

"First, No system is safe. Second, Aim for the impossible. Third no Backup, no Mercy" - Schnittlauch

My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved.