• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Conver numbers to text

Engaged ,
Sep 23, 2006 Sep 23, 2006

Copy link to clipboard

Copied

Does anyone have a code for converting a number to a text string, as in convert $123.45 to One Hundred Twenty Tree Dollars 45/100?

I am writing an invoicing module for a client and would like to add this feature, so below the invoice summary the total amont is given in words. I could write it myself, but thought I should ask first, maybe someone has it written already... how lazy am I...

Oh, it should be able to convert mubers up to 999,999.99 ....
TOPICS
Advanced techniques

Views

240

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advisor ,
Sep 23, 2006 Sep 23, 2006

Copy link to clipboard

Copied

Yeah, Ben Forta wrote a function that does this, "NumberAsString()":
http://www.cflib.org/udf.cfm?ID=40

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Sep 23, 2006 Sep 23, 2006

Copy link to clipboard

Copied

LATEST
cheers, MikerRoo! i must have missed that one somehow...

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation