Cardinal numbers
You can create a User Defined Function in Access to covert numbers to words.
The function can be used in a calculated field or control in a form or report.
From the Microsoft Knowledgebase collection:
How to Convert a Numeric Value into English Words
Also:
The Access Web (MVPS)
Convert Currency ($500) into words (Five Hundred Dollars)
TECH on the Net.com
Convert currency into words
(The Access code also works in Excel)
To create Cardinal numbers in Excel see:
Excel - Numbers to Words
(The Excel code also works in Access)
Word appears to be the only Office app with a built in cardinal number function.
For Word see:
Word - Numbers to Words
See all Topics
No comments:
Post a Comment