| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto spelled number
Thanks to both Bob and John for your advice
Shamsul "Bob Phillips" wrote: See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ShamsulZ" wrote in message ... I'm have been looking for a formula in Excel to automatically generate a sentence in Excel from a number in single cell. E.g in A1 cell the no. is 100.50, I want Excel to auto generate "Dollars : One hundred and cents fifty only' in C1. In this way I dont have to waste my time spelled and avoid any mistakes. Thanks friends |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does my name get spelled wrong?? | Excel Discussion (Misc queries) | |||
| When inserting date , how do I have the month spelled out | Excel Worksheet Functions | |||
| How to correct a mis-spelled word not in Dictionary? | Excel Discussion (Misc queries) | |||
| Convert a positive number into spelled-out text | Excel Worksheet Functions | |||
| from a cell which has numbers how to get it spelled | Excel Worksheet Functions | |||
Hybrid Mode
