With some rework of the Microsoft Access code http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q210586&; I was able to create this test page. According to Microsoft and my knowledge, Chris Tifer is right, you only put "and" at the decimal (between the dollars and cents).
Check out this sample with implementing a slightly tweaked code: www.charlesmarshall.com/currency.asp Thanks, Carlos -----Original Message----- From: Chris Tifer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:13 PM To: ActiveServerPages Subject: Re: Currency to Words function for ASP I specifically remember in business class that when writing checks, you don't specify an "and" until you get to the cents. But like I mentioned earlier, I've never written a million dollar check and they didn't even bother to teach us about those (no forward thinking on their part). Chris Tifer ----- Original Message ----- From: "Bostrup, Tore" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Wednesday, August 28, 2002 6:58 AM Subject: RE: Currency to Words function for ASP > Right, but between the hundreds and the tens, I would have expected > one (i.e. INSIDE the three digit groups - not between them). > > Tore. > > -----Original Message----- > From: Chris Tifer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 28, 2002 12:46 PM > To: ActiveServerPages > Subject: Re: Currency to Words function for ASP > > > Well, I know when writing checks, there is definitely NO "and" between > thousands and hundreds. When I write my first Million dollar + check, > I will let you all know for sure on the bigger numbers. Or, if I find > something on a search engine :-) > > Chris Tifer > > > ----- Original Message ----- > From: "Bostrup, Tore" <[EMAIL PROTECTED]> > To: "ActiveServerPages" <[EMAIL PROTECTED]> > Sent: Wednesday, August 28, 2002 6:37 AM > Subject: RE: Currency to Words function for ASP > > > > I don't know if there's an "official" standard for this, but I would have > > thought that each group (of three digits) would include an and: > > > > $1,253,812 => > > One million two hundred and fifty three thousand eight hundred and twelve > > dollars > > > > Tore. > > > > -----Original Message----- > > From: Bleier, Brenda G (SAIC) [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 28, 2002 9:12 AM > > To: ActiveServerPages > > Subject: RE: Currency to Words function for ASP > > > > > > you are correct Chris! > > > > -----Original Message----- > > From: Chris Tifer [mailto:[EMAIL PROTECTED]] > > Sent: August 28, 2002 10:54 AM > > To: ActiveServerPages > > Subject: Re: Currency to Words function for ASP > > > > > > Just so you're aware, I believe "and" is only used when describing > > the cents portion. The current output you showed is correct. > > > > Anyone else think differently? > > > > Chris Tifer > > http://www.emailajoke.com > > > > > > > > ----- Original Message ----- > > From: "Matthew Tarzwell" <[EMAIL PROTECTED]> > > To: "ActiveServerPages" <[EMAIL PROTECTED]> > > Sent: Tuesday, August 27, 2002 5:14 PM > > Subject: Currency to Words function for ASP > > > > > > Hi Everyone, > > > > This is a great list and always has interesting discussions. > > > > My questions is, does any one have an VBScript or Visual Basic > > function that converts a currency variable to a written string? The > > current one we have works well, but it is doesn't handle every > > situation. > > > > For example when using his number $1,302,200.00 > > it prints "One Million Three Hundred Two Thousand Two Hundred > > Dollars" > > > > But we are looking for one that properly includes an "and" where > > appropriate. So the above example would read "One Million Three > > Hundred and Two Thousand Two Hundred Dollars" > > > > We are not really sure which (if either) is considered proper. But > > it is for an insurance application, if it sees rather picky. Thanks > > for you help! > > > > Matthew > > > > > > > > --- > > You are currently subscribed to activeserverpages as: > > [EMAIL PROTECTED] To unsubscribe send a blank email to > > %%email.unsub%% > > > > > > --- > > You are currently subscribed to activeserverpages as: > > [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% > > > > --- > > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > > %%email.unsub%% > > > > --- > > You are currently subscribed to activeserverpages as: > > [EMAIL PROTECTED] To unsubscribe send a blank email to > %%email.unsub%% > > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > %%email.unsub%% > > --- > You are currently subscribed to activeserverpages as: > [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
