Question about Computers & Internet
Posted by Anonymous on
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
The short of it is this ...
Match the data in each location and store it the same way. As a number or as a string. I would say, looking at your data, that these are probably strings of numbers. Put the apostrophe in front of both pieces of data at both locations so they match. I tried a simple test in Excel and adding the apostrophe in front of all the uses of this data will match everything.
The long of it is this ...
Now, I don't know your technical expertise, but I'll try to put it simply. The hard part to understand in database and data storage, is that not all numbers are numbers.
For example, a phone number 8005551212 is not a number. It's a string of numbers. This is because every single position from the 8 to the 2 is a significant position. Another example is a a social security number. The arbitrary SSN of 002003421 is a string of numbers. The first two 0's will be stripped off in Excel if put in as a number, thus ALL number but be retained in their original significant position.
The apostrophe (added by the user) forces Excel interpret the cell data as a string, instead of number, preserving all the characters in their original form, and doesn't try and tinker with the formatting.
The other reason is that the data you've provided is WAY BIG for a number. Not a lot of systems in the world will do calculations against such big numbers. This is why I "guess" that they should be strings (adding the apostrophe to the front of the data in the cell).
How do you know if data should be stored as a string or as a number. The tall tale question is "will I be using these numbers in calculations." If you do, it's a number, if not, it's a string (add the apostrophe). A second question could be "do I need all positions to retain their original information" as a literal.
Please ask any questions.
Posted on Dec 18, 2007
Tips for a great answer:
Mar 27, 2015 | Computers & Internet
Jul 29, 2012 | FixYa Computers & Internet
May 02, 2011 | Computers & Internet
Apr 01, 2011 | Computers & Internet
Oct 20, 2010 | Computers & Internet
Jun 11, 2010 | Microsoft Excel for PC
Oct 27, 2009 | Intuit QuickBooks Pro 2007 Full Version...
Apr 01, 2009 | SPSS 13.0 (30960UU)
Dec 18, 2007 | Microsoft EXCEL 2004 for Mac
661 people viewed this question
Usually answered in minutes!