| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
New columns won't calculate
Hi,
I've been sent a spreadsheet which doesn't appear to be locked or protected, in that it is possible to edit data and to add and delete columns. Formulae are calculating normally in existing columns, but when I added a new column and entered a formula, it showed the formula rather than the result. If anyone has any idea what might cause this to happen and how it can be prevented advice would be most appreciated! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
New columns won't calculate
Hi
It sounds as though those extra columns have been pre-formatted as text. Mark the columnsFormatGeneral Then when you enter your formulae, they should work. -- Regards Roger Govier "glitterbug99" wrote in message ... Hi, I've been sent a spreadsheet which doesn't appear to be locked or protected, in that it is possible to edit data and to add and delete columns. Formulae are calculating normally in existing columns, but when I added a new column and entered a formula, it showed the formula rather than the result. If anyone has any idea what might cause this to happen and how it can be prevented advice would be most appreciated! Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
New columns won't calculate
Thank you, that's exactly it and very helpful!
"Roger Govier" wrote: Hi It sounds as though those extra columns have been pre-formatted as text. Mark the columnsFormatGeneral Then when you enter your formulae, they should work. -- Regards Roger Govier "glitterbug99" wrote in message ... Hi, I've been sent a spreadsheet which doesn't appear to be locked or protected, in that it is possible to edit data and to add and delete columns. Formulae are calculating normally in existing columns, but when I added a new column and entered a formula, it showed the formula rather than the result. If anyone has any idea what might cause this to happen and how it can be prevented advice would be most appreciated! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate average in a cell from one of two columns | Excel Worksheet Functions | |||
| calculate best 4 out of 6 columns | Excel Worksheet Functions | |||
| compare two columns, then calculate a result | Excel Discussion (Misc queries) | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| How can I calculate columns? | Excel Worksheet Functions | |||
Linear Mode
