| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why are the calculations incorrect in my spreadsheet?
This one's really got me confused...
i'm using someone else's spreadsheet but for some reason this is not allowing me to enter formulae, it just gives me an answer of 0, even for a simple sum. I've checked and it doesn't look like the cells are protected at all . What on earth's going on? Can anyone help ?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why are the calculations incorrect in my spreadsheet?
open a new XL.. copy a blank cell and go to your main XL "Select All" right
click and click on "Paste Special" and then click"format" and click ok.. i hope it would be done "Peepdip" wrote: This one's really got me confused... i'm using someone else's spreadsheet but for some reason this is not allowing me to enter formulae, it just gives me an answer of 0, even for a simple sum. I've checked and it doesn't look like the cells are protected at all . What on earth's going on? Can anyone help ?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
| Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
| Copy From One Spreadsheet To Another Spreadsheet | Excel Discussion (Misc queries) | |||
| Formulas in the spreadsheet I use as a model are now incorrect. | Excel Discussion (Misc queries) | |||
| Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Linear Mode
