Number Stored As Text - Convert to number in code

[divster27]

Hi,

I get a daily spreadsheet from a supplier where a few of the columns need converting to number, which i can do by selecting the cells, right click, convert to number

I tried storing this as part of a macro, but i can't get it to work.

Is there a code snippet i could add into my macro to get it to work?

David

 

[JEC]

Probably like

with sheet1.usedrange
   .value = .value
end with

 

[divster27]

Thanks for getting back to me, but i'm not a coder, so i can't get that to work

Fist of all i need to sleect the range of cells i need to convert, then apply an action - the below is what i have tried
Click on Cell N2
Then select all from that point down
then?
thanks for any help

With Range("N2").Select
Range(Selection, Selection.End(xlDown)).Select
.Value = .Value
End With

 

[JEC]

It should not make any difference. remove all code and paste this

Sub jec()
 With Activesheet.UsedRange.Columns(14)
   .Value = .Value
 End With
End Sub

 

[divster27]

Still can't get that to work

Book1
	P
6
Sheet1