Excel...not!

Note: red=rant
You may skip ahead to normal-coloured text.

Excel is SO stupid! I type in a number followed by the % symbol, and it converts the cell to a percentage. So far, so good. But later, if I change the cell format to general, text, or number (or probably whatever else) it changes my percentage into a number. A number less than 1. It's not even smart enough to just take away only the percent symbol, it has to change what I wrote. I would understand if it did that for the format "number", but general and text…well, if I chose that it means that I want what I wrote to be what's in the cell, doesn't it? So instead of typing it once, I have to type the percentage in, then change the format to text, and THEN retype the percentage because Excel thinks it's very smart, "helping" me to change what I wrote. GRRR…

It isn't the first time it's happened, which is why it's so frustrating! Imagine if you want to change the format of a whole lot of cells at the same time…

Next time I shall think ahead and change the cell format to text first.

I actually like Excel a lot, but there are these little things that make me wonder sometimes...what on earth were those Excel programmers thinking?!

Another weird thing Excel does is about dates. It sometimes converts the date automatically, like when I type 06/2008, Excel will convert it to June 2008 (something like that) But in the cell, instead of 06/2008, it suddenly contains 01/06/2008. And here comes the coup de grace: if I convert it into text or a number, it turns into 39600. I have no idea how that number is calculated, I'd appreciate it if someone can tell me! I tried 12/2008, and the number it gives me is 39783. Anyone want to solve the puzzle? I can't be bothered right now...if I'm bored one day I might give it a try! lol

By the way, I saw a princess in the bus today. She was wearing a blue dress complete with a tiara and a wand (er, a fairy princess maybe? :P ) Okay, it was a little girl. I wonder where she was going/coming back from...