ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Is it possible to convert numeric figures in to words like (1,200. (https://www.excelbanter.com/excel-worksheet-functions/114440-possible-convert-numeric-figures-words-like-1-200-a.html)

GANESH

Is it possible to convert numeric figures in to words like (1,200.
 
Is it possible to convert numeric figures in to words?
Examble: if one value is 1,250.00, i wanted it to be converted to other cell
as "One thousand two hundred fifty only." If there is any formula in excel
kindly inform me please.

Thanks & Regards
GANESH

Gord Dibben

Is it possible to convert numeric figures in to words like (1,200.
 
Check out Bob Phillips' site for help on this.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Sat, 14 Oct 2006 09:26:01 -0700, GANESH
wrote:

Is it possible to convert numeric figures in to words?
Examble: if one value is 1,250.00, i wanted it to be converted to other cell
as "One thousand two hundred fifty only." If there is any formula in excel
kindly inform me please.

Thanks & Regards
GANESH




All times are GMT +1. The time now is 08:57 PM.

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