Storing numbers in text fields
 

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.

Storing numbers in text fields
 

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.

Storing numbers in text fields
 

Turn off that error checking.

Tools|Options|Error checking tab (in xl2003)

wrote:

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.

--

Dave Peterson

Storing numbers in text fields
 

Yo Barry ...

Did you try either:

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