value in words against the value in numbers- help needed
From the cells B2 to B18 I have some values in USD.
In B19 the sum of B2 to B18 is there. ( for example $ 1250.85) Now In the cell B21 I need the wording corresponding to the figure found in B19 (Example: USD. One Thousand Two Hundred and Cents Eighty Five only) Can any one help me. t.thirumurthi |
value in words against the value in numbers- help needed
Check the MS site for 'spellnumber':
http://support.microsoft.com/default...b;en-us;213360 "news" wrote: From the cells B2 to B18 I have some values in USD. In B19 the sum of B2 to B18 is there. ( for example $ 1250.85) Now In the cell B21 I need the wording corresponding to the figure found in B19 (Example: USD. One Thousand Two Hundred and Cents Eighty Five only) Can any one help me. t.thirumurthi |
value in words against the value in numbers- help needed
news Wrote: From the cells B2 to B18 I have some values in USD. In B19 the sum of B2 to B18 is there. ( for example $ 1250.85) Now In the cell B21 I need the wording corresponding to the figure found in B19 (Example: USD. One Thousand Two Hundred and Cents Eighty Five only) Can any one help me. t.thirumurthi Try this link http://www.excelforum.com/showthread...umbers+ words -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=478470 |
value in words against the value in numbers- help needed
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH RP (remove nothere from the email address if mailing direct) "news" wrote in message ... From the cells B2 to B18 I have some values in USD. In B19 the sum of B2 to B18 is there. ( for example $ 1250.85) Now In the cell B21 I need the wording corresponding to the figure found in B19 (Example: USD. One Thousand Two Hundred and Cents Eighty Five only) Can any one help me. t.thirumurthi |
All times are GMT +1. The time now is 01:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com