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?
Bookmarks