Converting Numerical Values Into Text

C

cleadavis

This is a bit complicated but:

I am trying to import numerical values to create a "Custom List". I
order to do this I need to change the numerical values into text.
have reformatted the cells using the "Text" option but the Custom Lis
import facility does not recognise this change unless I have edite
each cell in turn using the F2 and Return keys. Fine if there are onl
a few rows of data but a nightmare if there are several hundred rows o
data. Which there are. Does anyone know of a simpler, more efficient wa
of "validating" the conversion from numerical values into text?

Thank you and good night,

Cle
 
G

Guest

Try using the CONCATENATE function. For example, if cell A1 has a numerical
value of 123 and you place the function =CONCATENATE(A1) in cell B1, then B1
will be the text value "123."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top