Hi,
Only now I have understood what were the causes of differences in processing between 2003 and Excel 2007
When retrieving data from the web (an external procedure to excel) I get some values in a column in string format.
The whole column always contains positive values such: 34,12
I checked with a macro ZTEST you can fix it.
Waiting for suggestions for a better solution!Code:Sub Enter_Values() Dim x As Variant Dim Xcell As Variant For Each Xcell In Range("F2:F25000") ' Selection Xcell.Value = CDec(Xcell.Value) Next Xcell End Sub Sub Decimali() Dim x As String With Range("F2:F" & Range("F" & Rows.Count).End(xlUp).Row) x = .Address .Offset(, 3) = Evaluate("if(isnumber(" & x & "),round((" & "int(" & x & "* 100" & ")),0)/100," & x & ")") End With End Sub Sub ZTest() Call Enter_Values Call Decimali End Sub




Reply With Quote
Bookmarks