lotus 123 how to convert amount in figures into amount in words

[ajodinec29]

i am currently making a template using lotus 123. how can i convert amount in figures into amount in words. exhp100.00 on A1 then A2 will automatically display the "one hundred pesos". is there any formula for this?

 

[DuffyTaylor]

I think I might have something will help you. You will need to adapt it from dollars to pesos and it does have limitations but it might work for you. If you get past the 10,000 limit, please let me know. Thank you.

I cannot determine how to attach the file.

 

[DuffyTaylor]

I need to determine how to upload the file to you. If anyone can help me with that I would most appreciative.

 

[enigma9051]

Place the formula somewhere on the web and reference it at step 3 in the reply box (below the area where you type). I added a bogus address (Microsoft) as an example.