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

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;Q213360&;

--
Gary''s Student - gsnu200757


"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

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