ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW TO TRANSLATE FIGURES TO AMOUNT IN WORDS (https://www.excelbanter.com/excel-worksheet-functions/180637-how-translate-figures-amount-words.html)

TUNJI

HOW TO TRANSLATE FIGURES TO AMOUNT IN WORDS
 
IN MICROSOFT EXCEL, IS THERE ANY FORMULA BY WHICH THE 'FIGURE' THAT APPEAR IN
A CELL CAN BE TRANSLATED TO 'WORDS' IN ANOTHER CELL? E.G. IF CELL A3 CONTAINS
195, CAN WE MAKE CELL A5 TO READ 'ONE HUNDRED AND NINETY FIVE'?

Gary''s Student

HOW TO TRANSLATE FIGURES TO AMOUNT IN WORDS
 
http://support.microsoft.com/default...EN-US;Q213360&
--
Gary''s Student - gsnu200774


"TUNJI" wrote:

IN MICROSOFT EXCEL, IS THERE ANY FORMULA BY WHICH THE 'FIGURE' THAT APPEAR IN
A CELL CAN BE TRANSLATED TO 'WORDS' IN ANOTHER CELL? E.G. IF CELL A3 CONTAINS
195, CAN WE MAKE CELL A5 TO READ 'ONE HUNDRED AND NINETY FIVE'?


Bob Phillips

HOW TO TRANSLATE FIGURES TO AMOUNT IN WORDS
 
See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TUNJI" wrote in message
...
IN MICROSOFT EXCEL, IS THERE ANY FORMULA BY WHICH THE 'FIGURE' THAT APPEAR
IN
A CELL CAN BE TRANSLATED TO 'WORDS' IN ANOTHER CELL? E.G. IF CELL A3
CONTAINS
195, CAN WE MAKE CELL A5 TO READ 'ONE HUNDRED AND NINETY FIVE'?





All times are GMT +1. The time now is 07:25 PM.

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