| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to return a number into letters?
Hi there,
I am working in Excel worksheet that represents an invoice. When the total price is calculated I need to translate the invoice sum into a phrase. Example: Quantity Product Name Unit Price Total Price 10 Product 1 $39.80 $398.00 35 Product 1 $21.30 $745.50 -------------------------------------------------------- Total Invoice $ 1'143.50 [Only One Thousand One Hundred Forty Three & 50/100 USD] the phrase in the parenthesis is what I am talking about. Is there a function in the Excel 2007 that converts numbers into it's value in letters? Thank you for your time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SWITCH NUMBER BY LETTERS | Excel Discussion (Misc queries) | |||
| number to letters | Excel Discussion (Misc queries) | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| In Excl how can I return letters to the columns I now have numbers | Excel Discussion (Misc queries) | |||
| Return column letters to spreadsheet. | Charts and Charting in Excel | |||
Threaded Mode
