When I copy a Jet Report to Excel and try to create a lookup table the "vlookup" function does not work because the first column in the lookup table is formatted as text. I tried several copy/paste special options to convert the values in the first column to numbers. I tried formatting the column as General. The only thing that works is pressing [F2] then [Enter} on each cell. How do I convert the entire column to General format in my Excel spreadsheet?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
So the Jet function is returning a string because in your database that data is a string. I'm guessing maybe it's a NAV code field or something like that where the field is a string, but you're storing numbers in it. You should be able to use the Excel VALUE function to convert the result of the Jet function to an Excel numeric value. Does that help?
Regards,
Hughes
Please sign in to leave a comment.