Hi,

I'm having a problem with a lookup formula because there appears to be a hidden character in from of the number i'm trying to look up.

I have down loaded the original data from an external source and opened the file in excel as a text file.

For indivdual cases I can correct the problem by clicking in from the number and hitting backspace but I need a quicker fix for the whole worksheet.

Please help.