Thread: Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cranen cranen is offline
external usenet poster
 
Posts: 28
Default Format

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?