I am importing data that has hundreds of numbers like 60003838, 60010813,
60003928, 60003895. I would like to know if there is a way to format the data
to change those numbers automaticaly to another value (names) every time I
import the data, or is there a way for me to replace all those values
automatically?

If you have a list that has names behind these numbers you can use a vertical
lookup function ( VLOOKUP ).


Use Insert - Function, and search for VLOOKUP function and follow the
instructions.

Hope this helps.


"Jake" wrote:

> I am importing data that has hundreds of numbers like 60003838, 60010813,
> 60003928, 60003895. I would like to know if there is a way to format the data
> to change those numbers automaticaly to another value (names) every time I
> import the data, or is there a way for me to replace all those values
> automatically?
>