Saturday 11 November, 2006

Number to text converter

I can't remember why, but I set myself a personal challenge to create a spreadsheet that could convert numbers to text.

Here it is. Type in a number between 1 and 999,999 in the red cell and it will write it out in words in the blue. English style, not American, so the ands are included.

As an aside, the lowest positive integer for which the letter a is required is 101 (one hundred and one). In American, it's 1,001 (one thousand one).


Posted by dan at 9:16am | Permalink | Comments (1) | Trackbacks (0)
Comments

As an aside, the lowest positive integer for which the letter z is required is 100000...00000 (one zillion). In France, it's 3 (zrhee).

Posted by Thomas 3:33pm, Saturday 11 November 2006
Add comment (all comments are currently moderated)
Your name*
Enter the confirmation code* You don't have GD support compiled in, we cannot create an authimage. Please activate GD Support.
Comments *



* denotes a mandatory field