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...
Hi
The conditional formatting doesn't change the actual content of the cells but just makes them 'appear' different. So if you conditionally format a number e.g. 234 to have a leading zero, if will look show 0234 in the cell but if you click into the cell and look at the formula bar you will see that the actual content of the cell is still 234 and not 0234. Do you need to display the leading zeros? Are they in the original file you are copying from? have you explored all the 'paste as' options? Are you just pasting values? Finally, should your vlookup contain a 'true' argument to make it look for an exact match only?