I have a list of text and Numbers for eg:

1,2,3, A, B,C

and I called it into a cell (A1) using Data validation>List.

Problem is that the value called in A1 auto formats to 'text' but I want to keep Numbers as Number and text as text only since I have Vlookup linked to A1,if A1 is Number it Vlookups one table and for text it Vlookups another table)

can any one help me to keep the orignal format of the input from the list.

regards

• Moved by Lanlan HuangMicrosoft contingent staff 5 hours 5 minutes ago

I can not reproduce the issue, this might be an issue in your file only.

Try to reproduce the issue within a new file:

- Make a new file
- Add a data validation to A1, use 1,2,3,A,B,C as list.
- Write the same items in column B
- Write 11,22,33,44,55,66 into column C
- Add the formula
  =VLOOKUP(A1,B:C,2,0)
  to D1

Works as expected!?

Andreas.

Hi

This is the forum to discuss questions about MS Excel develop (VBA). For your question is about formulas in Excel, I will move the thread to the TechNet forum for Excel.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards,

Lan