computing sums Holden Caulfield 11.07.2006 16:46:02 when i try to autosum a column of numbers, what im getting is the formula in the cell and not the sum. anyone know why this is happening? thanks in advance

Re: computing sums "Trevor Shuttleworth" <Trevor[ at ]Shucks.demon.co.uk> 11.07.2006 17:08:01 I suspect the cell where you are putting your AutoSum is formatted as Text Regards Trevor "Holden Caulfield" <HoldenCaulfield[ at ]discussions.microsoft.com> wrote in message news:F387DB27-F20E-41CF-8171-6F6438798084[ at ]microsoft.com... [Quoted Text] > when i try to autosum a column of numbers, what im getting is the formula > in > the cell and not the sum. anyone know why this is happening? thanks in > advance

Re: computing sums "Niek Otten" <nicolaus[ at ]xs4all.nl> 11.07.2006 17:09:21 The cell was formatted as text before the formula was entered. Format the cell as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "Holden Caulfield" <HoldenCaulfield[ at ]discussions.microsoft.com> wrote in message news:F387DB27-F20E-41CF-8171-6F6438798084[ at ]microsoft.com... | when i try to autosum a column of numbers, what im getting is the formula in | the cell and not the sum. anyone know why this is happening? thanks in | advance