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?

I have a similar problem when i import from access. i use this code as
a workaround.

'workaround code to get rid of the apostrphe's that are appended from
access export
Dim C As Excel.Range

ActiveSheet.Range("A1:G" &
XLapp.WorksheetFunction.CountA(ActiveSheet.Range(" A:A"))).Select 'this
line and above line should be together. they wrap when posted.

For Each C In XLapp.Selection.Cells
C.Formula = C.Formula
Next

try this and lemme know if it works

AR