Convert Text to Numbers

[Guest]

I have a query that calls a vb script that returns a string as #dd:mm:yy#1234#
I strip out the numbers between the # into query fields, hence A=dd:mm:yy
and b=1234.

The query is exported to excel hence I have a column called A and another
called B.

In Excel it assumes that column B is a text fields.

Is there a way in Access to force the field to be a number, or to call
something that would convert the text to a number?

Don't want to do it manually in Excel?

 

[OfficeDev18 via AccessMonster.com]

You might try the CLng() function. After stripping the information, your
assignment statement should be B = CLng(TempStripName). That should force B
to be outputted as a number.

Hope this helps,

Sam