Change "1,2,3..." to "one,two,three..."

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

Guest

How can I change "1,2,3..." to "one,two,three..." in Excel? Using Format or
does excel got this function build in? Thank you!
 
No built-in. At http://www.xldynamic.com/source/xld.xlFAQ0004.html there are
some examples of converting numbers to words, but they tend to be for
monetary amounts, so you will probably need to call it a number of times and
concatenate the results.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

sum last 3 numbers greater that 0 in a range 0
How to change Colomn headings from (1,2,3,) to (A,B,C,) 3
R1C1 settings auto changing 5
Column Header is not in Letter 1
VLOOKUP isn't working properly in Excel on Mac 1
Column headings 2
Column and Row Labels 1
Voice Recognition in Excel 1

Back
Top