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. |
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