Hi,

I have a column which I format as follows -

Columns("B:D").NumberFormat = "@"

The issue is that some of the fields in this column contain numbers
and excel is flagging the fact that numbers are being saved as text. I
don't wan't excel to do this, what should I do?

Public value As String
...
Cells(RowCount, 3) = value

My column -

IDs

9899389
9A37884
9882D23
9288930

Thanks,

Barry.