Storing numbers in text fields

[bg_ie]

Hi,

I have a column which I format as follows -

Columns("B").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.

 

[Toyin.Butler]

Barry,

You could always use the following:

Application.ErrorCheckingOptions.NumberAsText = False

but remember to switch it back to true at the end of your code if
being used on other people's machines.

Regards,

Toyin.

 

[Dave Peterson]

Turn off that error checking.

Tools|Options|Error checking tab (in xl2003)

 

[gimme_this_gimme_that]

Yo Barry ...

Did you try either:

Cells(RowCount, 3).value = Cstr(value)
Cells(RowCount, 3).value = Format(value)