Numbers came in as text.

Format all cells as General.

Copy an empty cell.

Select the data range and Paste SpecialAddOKEsc

Now try the autosum.


Gord Dibben MS Excel MVP

On Wed, 19 Jul 2006 15:38:21 +0100, "DavidB" wrote:

Hi guys

I'm importing numbers from a custom application into excel, after the import
I cannot autosum, but if i manually remove the number and re-type it works
fine.

Any ideas?