Excel - Converting numerals to words
 

I'm using Excel 2003. I'm creating a spreadsheed into which many people will
be entering data. I'll then be merging the data to a Word 2003 document. My
document will need to have numbers written out, such as two or forty-nine
rather than 2 or 49.

2 questions, really:

Is there a way to make those entering data into spreadsheet to enter only
words in a column, rather than numerals?

Is there a way for me to convert numerals to words in a column?

Thanks.

Excel - Converting numerals to words
 

Convert the numbers to words

http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
__________________________________
HTH

Bob

"Veteran of the software cycles" <Veteran of the software
wrote in message
...
I'm using Excel 2003. I'm creating a spreadsheed into which many people
will
be entering data. I'll then be merging the data to a Word 2003 document.
My
document will need to have numbers written out, such as two or forty-nine
rather than 2 or 49.

2 questions, really:

Is there a way to make those entering data into spreadsheet to enter only
words in a column, rather than numerals?

Is there a way for me to convert numerals to words in a column?

Thanks.

Excel - Converting numerals to words
 

Numbers to words
Bob Phillips' site for help on this.

http://www.xldynamic.com/source/xld.xlFAQ0004.html

or Bernd Plumhoff's site

http://www.sulprobil.com/html/spellnumber.html

or

http://www.ozgrid.com/VBA/ValueToWords.htm

or

http://support.microsoft.com/?kbid=213360
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Veteran of the software cycles" <Veteran of the software
wrote in message
...
I'm using Excel 2003. I'm creating a spreadsheed into which many people
will
be entering data. I'll then be merging the data to a Word 2003 document.
My
document will need to have numbers written out, such as two or forty-nine
rather than 2 or 49.

2 questions, really:

Is there a way to make those entering data into spreadsheet to enter only
words in a column, rather than numerals?

Is there a way for me to convert numerals to words in a column?

Thanks.

Excel - Converting numerals to words
 

First question. Try Data Validation, requiring =NOT(ISNUMBER(--A1))

Second question:
http://support.microsoft.com/kb/213360
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://www.ozgrid.com/VBA/ValueToWords.htm
--
David Biddulph


"Veteran of the software cycles" <Veteran of the software
wrote in message
...
I'm using Excel 2003. I'm creating a spreadsheed into which many people
will
be entering data. I'll then be merging the data to a Word 2003 document.
My
document will need to have numbers written out, such as two or forty-nine
rather than 2 or 49.

2 questions, really:

Is there a way to make those entering data into spreadsheet to enter only
words in a column, rather than numerals?

Is there a way for me to convert numerals to words in a column?

Thanks.