Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert numbers to words (1000 to One Thousand) in Excel | Excel Discussion (Misc queries) | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
How do I spell numbers as words for writing checks in Excel? | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
words and numbers in an IF function | Excel Discussion (Misc queries) |