| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel considers my formulas as plain text
"Max" wrote: Did you re-confirm* the formula after ensuring the format was ok ? *eg: click inside the formula bar, press ENTER In fact, I'm not sure... ..the cell formatted as text would (normally) show only the result of the particular calculation formatted as text; not the entire formula. I'm not sure about that. Think cells which are pre-formatted as text would exhibit behaviour very similar to what you posted (Just tried it here <g) That's true. But it doesn't really solve my problem, since it has occured only when editing a perfectly well working formula... How about the calc mode of the book ? Is it set to Auto ? (Click Tools Options Calculation tab Automatic OK) Have to check this one out on monday when I'm back at the office... Kimmo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Excel Macro does not Replace text in formulas for several workshee | New Users to Excel | |||
| Excel formulas to create large blocks of text | Excel Discussion (Misc queries) | |||
| setting text qualifier in Excel | Excel Discussion (Misc queries) | |||
| How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
Threaded Mode
