Add padded zeroes to value in a cell?
Posted by Marc on May 24, 2001 4:11 PM
When I use VLOOKUP to compare the value in column A with column E, I don't get a match, because the value in A doesn't show as 11 digits. Some of the data has been padded with 4, 3, 2, or 1 zero. Is there a way to take the data as displayed in the column using a custom cell format and paste or convert it to the full 11 digit value? Example: Cell A2 displays 00002103910, the value is 2103910, and the data value in Column E is 00002103910. Hence no match.