Macro doesn't record formating "general" text into number

Hi,

I need a macro that will sort out a report for me. The report is dowloaded from our internal system and it needs to be sorted by ISBN number.
The ISBN are shown as numbers
e.g. 9780194070027
but there is a little green triangle in the top left hand corner of the cell and if you put the mouse cursor over it then a little box with a rhombus and an exlamation mark pops up. When you click on it, the message is "Number stored as Text" and you get the option to "Convert to Number." After choosing this option ISBN lookslike this:
9.78019E+12
So I then need to go into the formaling tools and choose "Number" and then also get rid of the decimal places.

I have tried to record those steps in a macro but nothing happens. Is there a way to record it so that it works properly?

Thanks.
The problem is that I need those ISBNs to be numbers because in the previous worksheet I have vlookup functions set up and without changing the ISBNs into numbers the vlookups don't work...
This is the macro code I have at the moment:
Columns("B:D").Select
Selection.Delete Shift:=xlToLeft
Columns("D:H").Select
Selection.Delete Shift:=xlToLeft
Columns("B:B").Select
Selection.Cut
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Range("A2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.NumberFormat = "0"

I'm sorry, I am not very good at excel, how would I create a vlookup function using VALUE?

At the moment, I have my first worksheet with a list of ISBNs (formated as numbers) in column A. The second worksheet has the dowloaded report with ISBNs that are not formated and a lot of other information which I have to pull through to the first worksheet. So, for example, to look up a price for specific ISBN my formula on the forst workseet is:
=VLOOKUP(A3,Invoice,4,FALSE)

Where do I stick the VALUE function?

Thank you!

!!! Got it !!!

Thank you Norie!

In my macro I have changed the ISBNs using the VALUE function and then copied and pasted as "special." It works!

Thank so much for your help!