Converting Numerical Values Into Text

  • Thread starter Thread starter cleadavis
  • Start date Start date
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
 
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."
 
Back
Top