amount of value convert in to words

[Rajendar]

Hi,

Please help me any one to get total amount of value in words

The amount of end word should be "Only"

attached file the column highlated in yellow

 

[PCosta87]

Hi,

You can use "&" in a formula to concatenate values and text into a String.
A very basic example can look something like this:

"=J34&" Text here"

If you still need assistance, post exactly how it should look like in the highlighted area. I didn't fully understand from your previous post.

Thanks

 

[Rajendar]

Dear Sir,
Example i given in the highlighted area

the total value is 1006.00. i just want to convert in to words

 

[PCosta87]

Hi,

Please refer to attached...
I already changed to use "Only" but you will need to do some more tweaking as this code is for dollars... should be easy enough though.

Source:https://support.microsoft.com/en-us...t-a-numeric-value-into-english-words-in-excel

 

[Rajendar]

Thank you Sir!

 

[PCosta87]

Thank you Sir!

You are welcome