| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to text with proper accounting for Cheque Printing
How to convert number to text with proper accounting for Cheque Printing.
10101.01 = Ten Thousand One Hundred One and One Only. 1000.00 = One Thousand Only. 1060.00 = One Thousand Sixty Only. I try a few posting solution, but for some result not properly done as i need. =SpellNumber(A1) If 1061 result "ONE THOUSAND SIXTY ONE ONLY" but if 1060 result "ONE THOUSAND SIXTY ONLY" with double space between "SIXTY" and "ONLY" but single space between "SIXTY" and "ONE". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert number to text with proper accounting for Cheque Printing
CD,
You could simply use =TRIM(Spellnumber(A1)) HTH, Bernie MS Excel MVP "CD" wrote in message ... How to convert number to text with proper accounting for Cheque Printing. 10101.01 = Ten Thousand One Hundred One and One Only. 1000.00 = One Thousand Only. 1060.00 = One Thousand Sixty Only. I try a few posting solution, but for some result not properly done as i need. =SpellNumber(A1) If 1061 result "ONE THOUSAND SIXTY ONE ONLY" but if 1060 result "ONE THOUSAND SIXTY ONLY" with double space between "SIXTY" and "ONLY" but single space between "SIXTY" and "ONE". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating cheque printing | Excel Worksheet Functions | |||
| Proper way to convert numbers to text | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
| convert a column of text to proper | New Users to Excel | |||
Linear Mode
