Forum Discussion
Problem with leading zero's, scientific notations, and pasting into a form
I am having a problem with a sheet I use for work, merging the data I get from a downloaded source correctly(also an excel format). I have been in the process of optimizing it to help catch errors be...
In department list you may convert numbers to texts such way
and use column with formulas as lookup array, values here will be kept as texts.
In downloaded file ORG are initially without leading zero
but even if they are, with opening csv file in Excel they are automatically converted to numbers, i.e. values without leading zeroes. To lookup them in departments list with texts as departments you may use
=VLOOKUP(TEXT(L6,"000000"),Departments!B2:C116,2,FALSE)and I'd recommend to use FALSE as last parameter, i.e. use exact match instead of approximate one.