Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invalid cell format in Excel
I am using LOOKUP in Excel, but it cannot recognize the format of the 'lookup
value' cell which is a 5-digi ZIP code. The data in that cell is imported from another application, and I cannot determine how it is formatted. As a result, Lookup returns an 'n/a'. Everything works fine if I delete the cell contents and enter the same value manually. I have tried reformatting the cell, moving the data from 'aligned left' to 'aligned right' with no success. I have also tried setting up an adjoining column which is the original column multiplied by one, and that doesn't work. Maybe if I could see how the cell is formatted, that could give me a lead ... Any ideas? Thanks. Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breaking links leaving invalid reference #REF! in cell | Excel Discussion (Misc queries) | |||
cannot open excel file - says invalid file format - what to do? | Excel Discussion (Misc queries) | |||
" invalid cell references. | Excel Worksheet Functions | |||
error/ file format invalid | Excel Discussion (Misc queries) | |||
Invalid Validation if cell "Delete"d | Excel Worksheet Functions |