As reported on Slashdot, Excel 2007 appears to have a major multiplication bug: The example first that came to light is =850*77.1 — which gives a result of 100,000 instead of the correct 65,535. It seems that any formula that should evaluate to 65,535 will act strangely. Can someone confirm this? I don’t have Excel 2007.
To display a dash (-) as the first character in a cell in Microsoft Excel (so it isn’t interpreted as a mathematical symbol), prefix the dash with an apostrophe, like so: ‘- This value begins with a dash. I’ve been programming in VBA for Excel and other products since VBA first came out, but I’m not an expert at using them as they were intended; I’d rather create a function
Darren Barefoot writes about one incident of Microsoft Excel’s misuse. I’ve seen it used as a word processer, for games, as a database, and a drawing program. I’ve received emails where the email’s content is in an attached Word document instead of in the email itself. I’ve seen Flash used for a web site when HTML will do. I’ve seen people use fancy, expensive programs to do screen captures when