Converting numbers to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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

Similar Threads

convert number into text & Only 3
How do I convert number into full text amount 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
How Can I Convert MBOX to HTML File? 0
Convert Date to Text 2
CONVERT NUMBER TO ENGLISH TEXT 2
Convert Text To Number 4
Windows 7 I need to convert date to text 3

Back
Top