Back in the day, no matter what the format of a cell, if you typed (sans quotes)...
"=n" where 'n' was any valid formula, Excel would evaluate and display the **result** of that formula.
In Excel XP, that has changed. For the much much worse.
Now... the format of the cell needs to be 'general'. If you forget, and type in the formula in a 'text' cell, you need to right-click, Format Cell, Number tab, select 'General' and Ok. Then you need to F2 to 'edit' the cell and hit 'Enter' to move off the cell. Then it will show you the result of the formula.
The best part? (wait for it.. this is good....) You can now safely switch the cell back to 'Text' format.
I find that, in general, I'm always SO pleased when a micro$oft program tries to guess what I want, and then attempts to "help". Ok, actually that's a tad cynical, actually, I'd give a lot for the opportunity to punch whoever is in charge of "Word". :roll:
Spot false dilemmas now, ask me how!
(If you're not on the edge, you're taking up too much room.)
I'm not much of an Excel formula dude and I don't have XP versions of MS Office, but it sounds like the deeper issue is that the default cell type must be "text" not "general", right? If that's the case, here's what I'd do: every time you start a new spreadsheet, select all cells (clicking on the little rectangle to the left of "A" and above "1" seems easiest), then change the cell type to general. (Hope this doesn't increase the file size hugely.) (I'm the guy who secretly goes into everyone's spreadsheets, selects all cells, and changes the text alignment to "Vertical | Top". Shhh!)
to all the techies here in the ranch, what would be the best office suite then, the much publicised Mikerowesoft versions or open office? or is there anything else, that competes. Just like to know cause i was brought up with a mic row soft spec comp all my days. Davy
I've been using Open Office for a while. There are a few flakes, but some things are better thought out than the Microsift equivalents. My machine didn't come with Word or Excel, so the price is right too. Open Office is close to comparable; there's little reason not to try it. For me, one thing has been worth the switch alone: the Open Office word processor has an export to PDF feature built right in, something that's essential to me. Saves me from the additional cost of purchasing Acrobat (I don't think Word supports this yet). -Jeff-