One of the users in the company I work for has a file with several hundred numbers in cells, which each one must he convert the number to it's translation into a word.
Example, 342.00 -> Three Hundred Forty Two
100.00 -> One Hundred
4,958 -> Four Thousand Fifty Eight
Is it possible in Excel to do that?
2006-07-25 08:14:35 · 2 answers · asked by Ya no estoy en Y!R por Facebook! 6 in Computers & Internet ➔ Software
yes it is possible but because there is no such built-in function in excel, it requires the use of code in the visual basic editor (tools > macros > visual basic editor).
simple instructions and the code needed can be found here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213360
it sounds like "Method 3: Paste Function" would be best for your particular task for running the code and doing the actual change.
2006-07-25 08:29:17 · answer #1 · answered by piquet 7 · 2⤊ 1⤋
100000
2016-03-26 21:02:41 · answer #2 · answered by Anonymous · 0⤊ 0⤋