Jeffrey Green
Well-known Member
- Joined
- Oct 24, 2007
- Messages
- 1,021
I have a column of 700,000 Dealer Codes. each is 5 alpha-numeric characters long, if that helps.
Most were just numbers but my Vlookup didn't work because of formatting. So i, right or wrong, copied a 1 and paste-specialed multiply that column, thinking in it would only "fix" the number fields. I was wrong.
i have thousands that return #value error.
The formula in those cells shows =("8402A")*1
I need that 5 digit code back! in this case, 8402A.
How do i do that?
Thanks
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
Most were just numbers but my Vlookup didn't work because of formatting. So i, right or wrong, copied a 1 and paste-specialed multiply that column, thinking in it would only "fix" the number fields. I was wrong.
i have thousands that return #value error.
The formula in those cells shows =("8402A")*1
I need that 5 digit code back! in this case, 8402A.
How do i do that?
Thanks
</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>