Convert Word to Number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Irshad Alam - 22 Jul 2007 07:10 GMT

I need a VBA code to convert my currency numbers into words :

For example I have a value in a Field : 1535.25
I want To be converted into One Thousand five hundred thirty five and twenty
five Fills

Please advise.

Regards.

Irshad

Reply to this Message

Allen Browne - 22 Jul 2007 08:11 GMT

See:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

You will need to adapt it from dollars and cents to fills, but it should
serve as an example of how to build such a function.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I need a VBA code to convert my currency numbers into words :
>
> For example I have a value in a Field : 1535.25
> I want To be converted into One Thousand five hundred thirty five and
> twenty five Fills

Reply to this Message

Irshad Alam - 22 Jul 2007 08:44 GMT

Thanks for your advise.

One Additional question i would like know, that if I have a field which has
Text, then it can be converted to number :

For example : My field has : One thousand five hundred fifty six and seventy
five fils
It can be converted to : 1556.75

Thanking you once again.

Regards.

Irshad

> See:
> Convert Currency ($500) into words (Five Hundred Dollars)
[quoted text clipped - 9 lines]
> > I want To be converted into One Thousand five hundred thirty five and
> > twenty five Fills

Reply to this Message

Allen Browne - 22 Jul 2007 08:53 GMT

It would be possible to write such a function, but I don't have an example
to point you to.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for your advise.
>
[quoted text clipped - 6 lines]
> five fils
> It can be converted to : 1556.75

Reply to this Message

Scott McDaniel - 22 Jul 2007 12:11 GMT

>I need a VBA code to convert my currency numbers into words :
>
>For example I have a value in a Field : 1535.25
>I want To be converted into One Thousand five hundred thirty five and twenty
>five Fills

Check this link:

http://www.freevbcode.com/ShowCode.asp?ID=6475

>Please advise.
>
>Regards.
>
>Irshad

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Reply to this Message