| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using countif function to add only a half of a number | Excel Discussion (Misc queries) | |||
| Is there a function that will return the page number? | Excel Worksheet Functions | |||
| Using the autofill function but increment by certain number in function | Excel Worksheet Functions | |||
| how to read number as string like '1243 = One thousand..' | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Linear Mode
