Convert number in figures to words

[RAJESH1960]

Hi, I am trying to convert a number in figures to words. It works correctly when the number is a 9 digit number. But if I enter a less than 8 digit number I don't get the expected answer. When I convert the figures into words, I do not want the headings in Row 4 to display, if the Cells in Row 5 is blank. Please enter a 9 digit number in cell C2 and check yourself to understand.

 

[RAJESH1960]

Worked perfectly....well done....something learned today !

Thanks Michael,
This is the first time I've used drop box. Hope it works.

Currency_1-01.xls

Downloaded your XL2BB ... Looks like tomorrow is going to be a long day, to work through it to get what I need. Thanks Giordano Bruno.

 

[RAJESH1960]

Thanks GB, You never know how helpful it will be. I would like to go through your workbook. Please....

Hi GB, I edited your formula as per my requirement, but I am not able to change the number of figures in the formula as per my need. Hope you will help me with it as I am learning something new. Please Note: If I change the figure in cell A1 it should automatically display the figures both converted into words in Row 6 and Row 9. I am not so perfect at formulas but I am trying to improve with every new lesson I take.

 

[RAJESH1960]

Hi GB, I edited your formula as per my requirement, but I am not able to change the number of figures in the formula as per my need. Hope you will help me with it as I am learning something new. Please Note: If I change the figure in cell A1 it should automatically display the figures both converted into words in Row 6 and Row 9. I am not so perfect at formulas but I am trying to improve with every new lesson I take.

This is the full image of my file. I am mixing both your and my file to arrive at the results.

 

[RAJESH1960]

This is the full image of my file. I am mixing both your and my file to arrive at the results.

The problem is Solved. Thanks for the help GB

 

[RAJESH1960]

The problem is Solved. Thanks for the help GB

Corrected.