Number formatting issue

3.79K viewsQuantrix Feedback
0

Hi:

I have some data that I am copyping from Excel to a Quantrix matrix. The text that I am having problems with is section numbers like xx.x.x.x and so forth. When a column of section numbers are copied into a matrix, only some of them covert correctly. Some cells still remain as numbers even after formating them as text in Quantrix. And, some section numbers like 14.2.5 in Excel become -692090 even if I format the cell as text.

It looks like two digit section numbers (xx.x) become numbers, three digit section numbers (xx.x.x) get converted to some large numbers, and four digit section numbers (xx.x.x.x) paste just fine.

Is this a bug? Or, can you please suggest a work-around or a fix? Thanks!

Let me know if you need to see the actual model and the spreadsheet that I am working with. Thanks.

0

Thanks for the work-around. I would appreciate the fix in the next patch. It is kind of weird why Quantrix is forcing it to be in date format when the user is applying a text format …. Thanks.

0

Hi – Thanks for your post.

What is happening with the 99.9.9 is that Quantrix is trying to turn that into a Date with a d.m.yy format. Quantrix should probably do something more relevant in this situation, like treat it as text. I will log this issue.

One workaround is to copy your data in Excel and paste to a text editor like Notepad. In the Text editor, put a single apostrophe in front of any values you want treated as Text in Quantrix. So it would look something like this.

‘99.9
‘99.9.9
etc…

Copy this data in Notepad and then paste into Quantrix for better results.

If anyone else has a different approach / workaround, please feel free to post.

-Mike

Latest Questions