ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i convert 100 in one cell to one hundred in another cell (https://www.excelbanter.com/excel-discussion-misc-queries/51745-how-do-i-convert-100-one-cell-one-hundred-another-cell.html)

Numbers into words

how do i convert 100 in one cell to one hundred in another cell
 
i want to convert number (that could also be result of a function) in one
cell to words. Example if one cell has 121 then in another cell it should
read one hundred twenty one.

Nick Hodge

how do i convert 100 in one cell to one hundred in another cell
 
This should work

http://support.microsoft.com/default...b;en-us;259663

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Numbers into words" <Numbers into
wrote in
message ...
i want to convert number (that could also be result of a function) in one
cell to words. Example if one cell has 121 then in another cell it should
read one hundred twenty one.





All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com