Which function can be used to Read the number in a cell ?
 

Here is the example for question detail:
- Cell A1 was input "5240"
- Need a function in cell B2 which shows "Five thousand two hundred fourty"

Thanks a lot./Best regards,
Vinc

Hi,

You could do this by downloading ASAP Utilities and use Numbers - Spell
Numbers or amounts.

http://www.asap-utilities.com/

Regards,
A


"Vinc" wrote:

Here is the example for question detail:
- Cell A1 was input "5240"
- Need a function in cell B2 which shows "Five thousand two hundred fourty"

Thanks a lot./Best regards,
Vinc