Results 1 to 5 of 5

Thread: [RESOLVED] [2005] Number (currency) to Word

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Sep 2006
    Location
    Surabaya, Indonesia
    Posts
    163

    Resolved [RESOLVED] [2005] Number (currency) to Word

    Hi

    I've made a little function to convert number to word. It seems goes well. However, I need a little advice about rules to convert it, since English isn't my primary language, and I forgot some of the rules.

    1. $ 101.
    Should be said One Hundred and One dollars (which I use) or just One Hundred one dollars?
    If it must use "and", then I should use "and" until 9 ($109: One hundred and nine dollars ?). And how about $110 (One hundred ten dollars or One hundred and ten dollars?).

    2. $ 101,101
    Should be said One hundred and one thousand one hundred and one dollars (which is my function do right now), or just One hundred one thousand one hundred one dollars ?

    If anyone can point where I might find the article about these rules, I'd appreciate it.

    Thanks.
    Check my Blog at VB Corner,Component Crafts

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,222

    Re: [2005] Number (currency) to Word

    This would be correct in the US:
    One hundred one thousand one hundred one dollars
    This would be correct in the UK and Australia:
    One hundred and one thousand one hundred and one dollars
    Given that English was invented in England, use the UK rules unless you're writing software specifically for the US. You could always localise it (or localize it in the US) for more than one culture.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Sep 2006
    Location
    Surabaya, Indonesia
    Posts
    163

    Re: [2005] Number (currency) to Word

    Even though you don't have to use "and" in US, but if you want to talk formally, you should use it, right ?

    And what range should I use "and" ? Does $ 110 considered One Hundred and ten dollars or one hundred ten dollars ?
    Check my Blog at VB Corner,Component Crafts

  4. #4
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,222

    Re: [2005] Number (currency) to Word

    You always use "and" if it's not an even hundred. It's a comma after the thousands and an "and" after the hundreds. If there are thousands but no hundreds then you omit the comma but include the "and".

    101: one hundred and one
    110: one hundred and ten
    199: one hundred and ninety-nine
    1001: one thousand and one
    1100: one thousand, one hundred
    1101: one thousand, one hundred and one
    1101101: one million, one hundred and one thousand, one hundred and one
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Sep 2006
    Location
    Surabaya, Indonesia
    Posts
    163

    Re: [2005] Number (currency) to Word

    I see. That's explained all. Thanks
    Check my Blog at VB Corner,Component Crafts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width