| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My autosum total is incorrect - what is wrong?
I'm doing a basic formula - about 400 entries to tota. I used autosum and my
total is incorrect. Is there a way to figure out if these cells are formatted as text and therefore not being read? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
My autosum total is incorrect - what is wrong?
In an adjacent column enter =ISNUMBER(cellref)
Copy down. Or without checking first you can format all as General. Copy an empty cell and select the data and EditPaste SpecialAddOKEsc. This should turn any text to numeric. Gord Dibben MS Excel MVP On Sat, 2 Sep 2006 20:00:01 -0700, Missing the obvious? <Missing the wrote: I'm doing a basic formula - about 400 entries to tota. I used autosum and my total is incorrect. Is there a way to figure out if these cells are formatted as text and therefore not being read? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with grand totals in pivot table | Excel Discussion (Misc queries) | |||
| Subtotal in a pivot table | Excel Discussion (Misc queries) | |||
| Autosum returns an incorrect zero value on the selected cells | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| Incorrect total | Excel Worksheet Functions | |||
Linear Mode
