Quote:
Originally Posted by Malaki86
i think you have to have the seperator in the number/date you're entering. I know you do in MS Office. For example, if I have a date format set to "mm-dd-yyyy", I have to at least enter "12/03" or "12-03". Office then adds the current year and formats the date correctly. The reason for this is that the computer uses a number code for the date & time. Most, but not all, use Midnight, January 1, 1970 as the start. January 2nd would be 1, 3rd would be 2, etc. So, entering "0631" tells the computer to use the date that matches that number, which would be the 631st day from when it calculates the dates.
For the number itself, you definitely have to enter the decimal point.
I believe you, but that is ridiculous! If I thought of it, millions of others have thought of it as well. You're entering a large string of numbers (I entered 43 fuel purchases today), each number has a two digit decimal, you're also able to format each cell, and yet the computer can't be told, 'hey dumbass, I'm going to enter numbers in each cell, the last two digits are hundredths'!?!?
Now that I think about it, there still must be a way. If nothing else, couldn't you enter a formula that divides the number you put into the cell by 100? I'd have to play with it, but I'm pretty sure it could be done. At worst, it would use up two columns.
Same thing with the date, too. If you are setting the format, the software ought to be able to receive dates coming in different forms.
All that aside, boy, I surely love this spreadsheet! It was a bit ominous at first, I didn't know where to begin. Then, I found a tutorial like Rev. said, and started working on it. I was actually having a lot of fun with it once I got comfortable with how to do it. Everything is a puzzle, how are you going to manipulate the data? I even figured out a good way to do it for those occasions when I didn't fill my tanks thus throwing off the standard mpg calculations.
I was really proud of myself, I've got all my fuel receipts posted as well as running totals on gallons pumped, cost, mpg. Your can really track your fuel useage closely this way. Who knows, maybe I'll start tracking more info regarding when I'm getting my best fuel mileage. Anyone notice you get great mileage coming back from California?
Soon, I'll have to set something up for all my other receipts, and figure out a way to get my fuel costs on this sheet to automatically post to that one. I've also got to figure out a way to back it up, too. I may go with one of those online services because I'd like to trade in this laptop while it's still under the Circuit City warranty.
Too much fun, today. I learnt something! Hey, that avatar is just like Stewie, too! :lol: