Question about Microsoft EXCEL 2004 for Mac
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
for Column E, if current cell is E(x) and previous cell is E(x-1) then,
formula will be:
=E(x-1) + C(x) - D(x)
logic: C is added to last balance, D is substracted the same way
Hope this helps.
Posted on Jun 18, 2009
Tips for a great answer:
May 06, 2011 | Samsung Galaxy Tab Tablet PC
Dec 15, 2010 | Microsoft Office Excel 2003 for PC
Aug 02, 2009 | Microsoft Office Excel 2007
Jun 29, 2009 | Lowrance iWAY 600C Car GPS Receiver
Jun 16, 2009 | Microsoft Computers & Internet
Aug 12, 2017 | Microsoft Visual FoxPro Professional...
Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)
Oct 08, 2008 | Microsoft Computers & Internet
Dec 19, 2007 | Computers & Internet
Dec 18, 2007 | Microsoft EXCEL 2004 for Mac
101 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: