20 as twenty in report

[m]

How can I get 21.95 to display as twenty-one and 95/100?

Help...please?

 

[Cheryl Fischer]

There is code available at the Access Web that will do that for you:

http://www.mvps.org/access/modules/mdl0001.htm

hth,

 

[Dirk Goldgar]

How can I get 21.95 to display as twenty-one and 95/100?

Help...please?

I think this function by Joe Foster may be what you're looking for:

http://www.mvps.org/access/modules/mdl0001.htm

 

[loadhigh]

Sorry,it's excel not access.

Here is answer.

 

[m]

Thanks!

There is code available at the Access Web that will do that for you:

http://www.mvps.org/access/modules/mdl0001.htm

hth,