View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
montse
 
Posts: n/a
Default "1235" appears as "One thousand two hundred thirty five"

do you know how do get this formula into access? i am doing my data entry
there and would like to have the numbers changed into words without having to
go back to excel.

"Norman Jones" wrote:

Hi Montse,

is there a vba writted for spanish? mil doscientos treinta y cinco?



You could download Laurent Longre's MoreFunc addin which is freely
downloadable at:

http://xcell05.free.fr/

The addin includes the NBTEXT function which converts a positive number into
spelled-out text (supports 13 languages).


---
Regards,
Norman