Number to text

[MN_Excel]

For v-lookup purposes I need a number field to display as a text. Simply choosing the text option doesn't seem to work. Any ideas on how to convert without having to add "+0" to the end?

 

[scottylad2]

I also got an issue with the sheet name...

If either the If the Isna is TRUE, the second if is redundant no? The Or will throw up "" if either ISNA(TRUE,(=o,TRUE either one will cause ""

 

[T. Valko]

I also got an issue with the sheet name...

If either the If the Isna is TRUE, the second if is redundant no? The Or will throw up "" if either ISNA(TRUE,(=o,TRUE either one will cause ""

You would do it like this...

=IF(ISNA(...),"",IF(VLOOKUP(...)="","",VLOOKUP(...)))

If the value being returned is TEXT then you can do this...

=IF(ISNA(...),"",T(VLOOKUP(...)))

 

[MN_Excel]

Thanks for all the input. I think the formatting issue was a result of the fact that I exported a document to a .csv file and then copied those values into excel. When I did the same export using an excel file the formatting issue disappeared. That is the only explanation I have. Does that seem logical?