How can i convert number to be stored as text?

[Guest]

Hi!
Is it possible to convert number to be stored as text? It is just for the
convenience of v-lookup.


Thanks!



Carole

 

[Niek Otten]

Use the TEXT() function

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Thanks! But how can i turn 48950 into text using text function. I need to
turn the cell into text - with a green corner which is they type of format of
the report which I need to look up to (the report 's codes are all in green
corners)

Thanks!
Carole

 

[Dave Peterson]

You could leave the values numbers and modify your =vlookup()

=vlookup(text(a2,"00000",.....)

or you could insert a helper column and put =text(a2,"00000") and drag down.

then copy that column and edit|paste special|values over the original column and
delete the helper column.

===
Another option would be to change the text values in the lookup table to
numbers.

copy a blank cell.
select that key column in your table
edit|paste special|check addition