EXCEL

This query is : Resolved 

25 March 2009 Dear Sir/Madam,
My quary is as below:

In excel if I type 100 they how it will appear "one hundred "
Menas please tell me formula how character are convert in to figures

Thanks and regards,
R.dutta,
E-Mail: rddutta@yahoo.com

26 March 2009 THERE IS NO ANY IN-BUILT FORMULA IN EXCEL THAT CONVERT FIGURES IN WORD, BUT IF YOU KNOW VB LANGUAGE YOU CAN DEVELOP YOUR OWN FUNCTION TO FULFILL YOUR REQUIREMENT. OR IT MAY BE READYLY AVAILABLE TO DOWNLOAD SCRIPT FROM NET IN SEARCH IF YOU SEARCH ENGINES.

26 March 2009 just in google/yahoo search bar type "formula to convert figures into word in excel" and you will get thousands of guidance. even ready VB module to just copy paste in excel.




You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries