EXCEL

This query is : Resolved

RAMU (Querist)
Follow

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

SHAILESH

SHAILESH (Expert)
Follow

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.

SHAILESH

SHAILESH (Expert)
Follow

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.