Format

[cranen]

I have item numbers that I enter into my worksheet that look like "327e000".
The item numbers don't always include an "e". The item number I enter in is
used by another cell for a VLOOKUP. So, when Excel formats it to Scientific
Form, the VLOOKUP doesn't work. Can I do a custom format to fix the problem?

 

[Jim Thomlinson]

Format the cells as text to keep them as text and avoid the conversion.