converting #dollars into word dollars?
I am creating a work order page for the company i work for. i want the dollar
sum of a column ($525.62) to be converted into words (Five Hundred twenty five dollars and sixty two cents) in a seperate cell. im dooing this for security so the numbers cant be fudged. Is this posable with a formula? The output dosent have to be that exact format but something close. thanks excel 2003 |
See he
http://support.microsoft.com/default...EN-US;Q213360& "hotrodenford" wrote in message ... I am creating a work order page for the company i work for. i want the dollar sum of a column ($525.62) to be converted into words (Five Hundred twenty five dollars and sixty two cents) in a seperate cell. im dooing this for security so the numbers cant be fudged. Is this posable with a formula? The output dosent have to be that exact format but something close. thanks excel 2003 |
Have a Look on this link:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q95640 To put in this function, from your workbook right-click the workbook's icon and pick View Code. This icon is to the left of the "File" menu this will open the VBA editor, in the left hand window click on your workbook name, go to insert, module, and paste the code in the window that opens on the right hand side, press Alt and Q to close this window and go back to your workbook. If you are using excel 2000 or newer you may have to change the macro security settings to get the macro to run. then use something like this in a cell =ConvertCurrencyToEnglish(5.25) or =ConvertCurrencyToEnglish(A4) Abdul Hameed "hotrodenford" wrote in message ... I am creating a work order page for the company i work for. i want the dollar sum of a column ($525.62) to be converted into words (Five Hundred twenty five dollars and sixty two cents) in a seperate cell. im dooing this for security so the numbers cant be fudged. Is this posable with a formula? The output dosent have to be that exact format but something close. thanks excel 2003 |
All times are GMT +1. The time now is 01:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com