Excel Multiply

[sms2luv]

I receive huge data which has number, but they are not formatted in number number, so I have to manually multiply them by 1.
Can I use xdown to select the data, so that all rows which has data can be selected.
If yes requesting you to help me with the code.

 

[Hui]

No Idea what XDown is ?

You can also use Text to Columns to change the Text to Numbers
Select the Data, Range or Column
Goto the Data, Text to Column tab
Delimitered, Next
Tick Tab, Next
Select General, Finish

 

[sms2luv]

Your idea is really great, however the data keeps adding to the sheet, so I cannot do text to column.
Please helpe with the macro for multiplication

 

[Nebu]

Hi:

Use the following code.

Sub test()
    With Range("A:A") 'specify your range here
        .NumberFormat = "General"
        .Value = .Value
    End With
End Sub

Thanks

 

[sms2luv]

Thanka for this.
Till now I was multiplying the data with the number 1 manually, because the result achieved with changing the format did not work as desired.

I started a macro recording, copied M1(which had the value of 1), then selected the range of a1 to h4000 and then selected paste special_multiple. I got the results as desired, however if the cells in the range were empty they got 0 values, which I don't want.
I viewed the code and found the below

Sub multi()
Sheets.Range("M1"). Copy
   With Range("A1:H4000").Select
Paste_Special.Multiply
EndSub

So I am planed to use Ctrl+Shift+Down arrow.
But not sure how to use it in macro.