{"id":12134,"date":"2012-04-09T16:37:15","date_gmt":"2012-04-09T16:37:15","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1560"},"modified":"2022-08-06T13:53:08","modified_gmt":"2022-08-06T13:53:08","slug":"currency-to-words","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/04\/currency-to-words\/","title":{"rendered":"User Defined Function in Excel to Convert Currency to Words"},"content":{"rendered":"
[et_pb_section fb_built=”1″ _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]Many times we require to change the Numbers in Words. For Example 6734862=Sixty Seven Lakhs Thirty-Four Thousand Eight Hundred Sixty Two.<\/strong> In Excel, there is no Formula as such to Convert Numbers into Words. I have written one UDF : User Defined Function<\/strong>. After using this Function, you will be able to change any numbers in Words. Now there can be two ways of converting Numbers into Words in terms of Millions, Billions, etc Another way could be in Lakhs and Crores. \n <\/p>\n