Converting numbers to text

[Guest]

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

 

[Guest]

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&;

 

[Guest]

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).