Convert Text to Number

[bstice]

I use excel automation to export data from access to excel. Often the numbers will come across as text and I use the little green arrow in the top left to convert the number value to text. What is the VBA code which would do the same thing. I have tried using the code to change the format to number, but it doesn't work. Thanks for your help~!!

Brennan

 

[hyperpau]

Seems like the only way you can do this is to change the format of your field to number by going to the design view of your table.

I use excel automation to export data from access to excel. Often the numbers will come across as text and I use the little green arrow in the top left to convert the number value to text. What is the VBA code which would do the same thing. I have tried using the code to change the format to number, but it doesn't work. Thanks for your help~!!

Brennan

 

[maxmangion]

try using the val() function