Hi HALinNY I did something like that many years back. Essentially you would create a series of lists in Excel. One list for zero to nine, another for ten to nineteen, another from twenty to twenty nine, etc.
Based on the number entered, we did a bunch of if conditions and then concatonated the result to another cell which displayed the number in words. We may have had to resort to some VBA, but I'm not certain. In the end the client wasn't quite happy with the result and then we developed a Foxbase solution. Don't know if it's still being used. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Hal Kaplan > Sent: Friday, March 16, 2007 2:02 PM > To: [EMAIL PROTECTED] > Subject: Whatchama Callit > > Hello, all. I hope you are all doing well and enjoying the relative > quiet resulting from my hiatus. > > I am back because this is arguably the most erudite group I know of and > I have a question that I am sure someone here will have the answer to: > > Is there an accepted name for the process of stating a number in written > words, that is 123 (one-hundred, twenty-three)? If so, what is the name > of the process? If I knew the name I could search for an answer to part > two. > > Part two is, does anyone have any hints for accomplishing this in <gasp> > Excel without using VBA? > > Thanks for your help and best wishes to all of you. > > B+ > HALinNY > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
