Hello,
I am getting a generated report from a customers website that i wish to extract data from
The column i wish to work with is an ID eg. 10001702 that i wish to use in a VLOOKUP.
The problem is the number is in an odd format, text or something so when i try to VLOOKUP it cannot recognize the number
Left justified like text instead of right justified like a number
clicking format cells and changing to number does not solve the issue
if i click on the cell containing the number, then click on the formula bar, then press enter, it will become a number. While this works its still a tedious method.
Is there a way i can find out how the number is formatted so i can set the vlookup to search for that?
or
is there a way i can add another column to in which it converts the number into a number format.
or any other solutions?
Hope people can follow that.
Thanks for any help
Bookmarks