Forum Discussion
kerry590
Aug 28, 2020Copper Contributor
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...
Poogermum
Aug 28, 2020Brass Contributor
kerry590 Hi I have tried to replicate your problem by pasting the data into the cover sheet but none of the values caused any issue. What formatting do the numbers actually have when they appear? Are they formatted as numbers or general? In which case I don't understand how the vlookup wouldn't find it.. Have you considered pasting only the values rather than values and formatting? Also, have you considered pulling the data from another sheet into the cover sheet using formulas to ensure consistency? you could pull all the values you need as number through using the convert from text formula (value()) and make sure that the cells are correctly formatted?