Excel: Convert Text to number in vba

[robdunfey]

Hi,

I import numbers from access into excel, but they are regarded as text in excel(aligned to left of cell). how can i programatically convert this text to numbers?

Any help much appreciated.

Rob

 

[Loomah]

Hi Rob
There may be some way of doing what you're looking for during the import process but I'm not too sure about things like that!

In the meantime the following will give an example of changing the format once into Excel. Note only use one of the options!

With Range("A1:A15&quot
'use one of these as an example
.NumberFormat = "General"
.NumberFormat = "#,##0.000"
End With

;-)

 

[acron]

Try

    Dim oCell As Range
    For Each oCell In Selection
        oCell = Val(oCell)
    Next

This works with the current selection. You can replace Selection with the address of a spcified range if that suits, e.g. For Each oCell In Range("A1:C100&quot

A.C.