Select the range of values you want to convert to text, press Ctrl + 1 (opens
the Format Cells dialog box), select the Number tab and apply the Text format
(in Excel 2007).
--
Gnothi se auton.


"Nicola" wrote:

Hi,

I have a long column of numbers and I need to have these numbers converted
into text, as would appear on a cheque for example. Is there an easy way of
doing this without me having to type the text in individually?

Thank you

Nicola