Date of Birth to word conversion

[Ganeszgk]

Respected sir/Madam,
[FONT=&quot]I have large number database of the Date of Birth 23/03/1985. The dob display another cell
[Twenty Three - March - Nineteen Fifty Eight].
For example:
A1: 28.8.1987
A2:[Twenty Eight-August-Nineteen Eighty Seven] this method want i.

How it work, please send coding will having and please to mention step by step process. Thank you..
i hoping...



[/FONT]
[FONT=&quot]<ins class="adsbygoogle sfadslot_1" data-language="en" data-ad-client="pub-3295671961621260" data-ad-slot="9304159522" data-adsbygoogle-status="done" style="box-sizing: inherit; background: none; color: rgb(0, 0, 0); text-decoration: none; min-width: 320px; max-width: 1200px; width: 540px; height: 220px; display: inline-block;"><ins id="aswift_1_expand" style="box-sizing: inherit; background: transparent; text-decoration: none; display: inline-table; border: none; height: 220px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 540px;"></ins></ins>
[/FONT]

 

[oldbrewer]

[TABLE="width: 1133"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]28/08/1987[/TD]
[TD]28/08/1987[/TD]
[TD]28[/TD]
[TD]08[/TD]
[TD]1987[/TD]
[TD]twentyeighth August Nineteen Eighty Seven[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01[/TD]
[TD]first[/TD]
[TD][/TD]
[TD]01[/TD]
[TD]January[/TD]
[TD][/TD]
[TD]1980[/TD]
[TD]Nineteen Eighty[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]02[/TD]
[TD]second[/TD]
[TD][/TD]
[TD]02[/TD]
[TD]February[/TD]
[TD][/TD]
[TD]1981[/TD]
[TD]Nineteen Eighty One[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]03[/TD]
[TD]third[/TD]
[TD][/TD]
[TD]03[/TD]
[TD]March[/TD]
[TD][/TD]
[TD]1982[/TD]
[TD]Nineteen eighty Two[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]04[/TD]
[TD]fourth[/TD]
[TD][/TD]
[TD]04[/TD]
[TD]April[/TD]
[TD][/TD]
[TD]1983[/TD]
[TD]Nineteen Eighty Three[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]05[/TD]
[TD]fifth[/TD]
[TD][/TD]
[TD]05[/TD]
[TD]May[/TD]
[TD][/TD]
[TD]1984[/TD]
[TD]Nineteen Eighty Four[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]06[/TD]
[TD]sixth[/TD]
[TD][/TD]
[TD]06[/TD]
[TD]June[/TD]
[TD][/TD]
[TD]1985[/TD]
[TD]Nineteen Eighty Five[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]07[/TD]
[TD]seventh[/TD]
[TD][/TD]
[TD]07[/TD]
[TD]July[/TD]
[TD][/TD]
[TD]1986[/TD]
[TD]Nineteen Eighty Six[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]08[/TD]
[TD]eighth[/TD]
[TD][/TD]
[TD]08[/TD]
[TD]August[/TD]
[TD][/TD]
[TD]1987[/TD]
[TD]Nineteen Eighty Seven[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]09[/TD]
[TD]ninth[/TD]
[TD][/TD]
[TD]09[/TD]
[TD]September[/TD]
[TD][/TD]
[TD]1988[/TD]
[TD]Nineteen Eighty Eight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[TD]tenth[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]October[/TD]
[TD][/TD]
[TD]1989[/TD]
[TD]Nineteen Eighty Nine[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]eleventh[/TD]
[TD][/TD]
[TD]11[/TD]
[TD]November[/TD]
[TD][/TD]
[TD]1990[/TD]
[TD]Nineteen Ninety[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12[/TD]
[TD]twelfth[/TD]
[TD][/TD]
[TD]12[/TD]
[TD]December[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]I converted the date to text, broke it into day month year[/TD]
[TD]13[/TD]
[TD]thirteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]and used 3 lookup tables[/TD]
[TD][/TD]
[TD]14[/TD]
[TD]fourteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]15[/TD]
[TD]fifteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]you can add more years to the last table[/TD]
[TD][/TD]
[TD]16[/TD]
[TD]sisteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]17[/TD]
[TD]seventeenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]and turn twentyeigth into twenty eight[/TD]
[TD][/TD]
[TD]18[/TD]
[TD]eighteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]19[/TD]
[TD]nineteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]20[/TD]
[TD]twentieth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]21[/TD]
[TD]twentyfirst[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]22[/TD]
[TD]twentysecond[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]23[/TD]
[TD]twentythird[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]24[/TD]
[TD]twentyfourth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[TD]twentyfifth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]26[/TD]
[TD]twentysixth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]27[/TD]
[TD]twentyseventh[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]28[/TD]
[TD]twentyeighth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]29[/TD]
[TD]twentninth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]30[/TD]
[TD]thirtieth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]31[/TD]
[TD]thirtyfirst[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Ganeszgk]

[TABLE="width: 1133"]
<tbody>[TR]
[TD="align: right"]28/08/1987[/TD]
[TD]28/08/1987[/TD]
[TD]28[/TD]
[TD]08[/TD]
[TD]1987[/TD]
[TD]twentyeighth August Nineteen Eighty Seven[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01[/TD]
[TD]first[/TD]
[TD][/TD]
[TD]01[/TD]
[TD]January[/TD]
[TD][/TD]
[TD]1980[/TD]
[TD]Nineteen Eighty[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]02[/TD]
[TD]second[/TD]
[TD][/TD]
[TD]02[/TD]
[TD]February[/TD]
[TD][/TD]
[TD]1981[/TD]
[TD]Nineteen Eighty One[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]03[/TD]
[TD]third[/TD]
[TD][/TD]
[TD]03[/TD]
[TD]March[/TD]
[TD][/TD]
[TD]1982[/TD]
[TD]Nineteen eighty Two[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]04[/TD]
[TD]fourth[/TD]
[TD][/TD]
[TD]04[/TD]
[TD]April[/TD]
[TD][/TD]
[TD]1983[/TD]
[TD]Nineteen Eighty Three[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]05[/TD]
[TD]fifth[/TD]
[TD][/TD]
[TD]05[/TD]
[TD]May[/TD]
[TD][/TD]
[TD]1984[/TD]
[TD]Nineteen Eighty Four[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]06[/TD]
[TD]sixth[/TD]
[TD][/TD]
[TD]06[/TD]
[TD]June[/TD]
[TD][/TD]
[TD]1985[/TD]
[TD]Nineteen Eighty Five[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]07[/TD]
[TD]seventh[/TD]
[TD][/TD]
[TD]07[/TD]
[TD]July[/TD]
[TD][/TD]
[TD]1986[/TD]
[TD]Nineteen Eighty Six[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]08[/TD]
[TD]eighth[/TD]
[TD][/TD]
[TD]08[/TD]
[TD]August[/TD]
[TD][/TD]
[TD]1987[/TD]
[TD]Nineteen Eighty Seven[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]09[/TD]
[TD]ninth[/TD]
[TD][/TD]
[TD]09[/TD]
[TD]September[/TD]
[TD][/TD]
[TD]1988[/TD]
[TD]Nineteen Eighty Eight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10[/TD]
[TD]tenth[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]October[/TD]
[TD][/TD]
[TD]1989[/TD]
[TD]Nineteen Eighty Nine[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]eleventh[/TD]
[TD][/TD]
[TD]11[/TD]
[TD]November[/TD]
[TD][/TD]
[TD]1990[/TD]
[TD]Nineteen Ninety[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12[/TD]
[TD]twelfth[/TD]
[TD][/TD]
[TD]12[/TD]
[TD]December[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]I converted the date to text, broke it into day month year[/TD]
[TD]13[/TD]
[TD]thirteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]and used 3 lookup tables[/TD]
[TD][/TD]
[TD]14[/TD]
[TD]fourteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]15[/TD]
[TD]fifteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]you can add more years to the last table[/TD]
[TD][/TD]
[TD]16[/TD]
[TD]sisteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]17[/TD]
[TD]seventeenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]and turn twentyeigth into twenty eight[/TD]
[TD][/TD]
[TD]18[/TD]
[TD]eighteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]19[/TD]
[TD]nineteenth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]20[/TD]
[TD]twentieth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]21[/TD]
[TD]twentyfirst[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]22[/TD]
[TD]twentysecond[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]23[/TD]
[TD]twentythird[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]24[/TD]
[TD]twentyfourth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]25[/TD]
[TD]twentyfifth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]26[/TD]
[TD]twentysixth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]27[/TD]
[TD]twentyseventh[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]28[/TD]
[TD]twentyeighth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]29[/TD]
[TD]twentninth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]30[/TD]
[TD]thirtieth[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]31[/TD]
[TD]thirtyfirst[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Respected Sir, this is not working., please tell about how it use. and coding or formula not having??

 

[oldbrewer]

column 1 is the date as a normal date
column 2 is the date in text format
cols 3,4,5 is the text format split into day month year
then we lookup the day (28) in the daytable and it returns "twentyeighth"
likewise "August" and "1987"
I then used concatenate to get them all together as text

Does that help ?

 

[Ganeszgk]

column 1 is the date as a normal date
column 2 is the date in text format
cols 3,4,5 is the text format split into day month year
then we lookup the day (28) in the daytable and it returns "twentyeighth"
likewise "August" and "1987"
I then used concatenate to get them all together as text

Does that help ?

Sorry sir. i tried like this is format. but i cannot get this result..

 

[oldbrewer]

make a new spreadsheet and put 25/02/2017 in A1
in B1 put =text(A1,"dd/mm/yyyy")

tell me what you get in B1

I will send you a spreadsheet but not until this post is deemed closed, because that is the rules of this forum.

 

[mjbeam]

=CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A1,FIND(".",A1)-1),"31","Thirty One"),"30","Thirty"),"29","Twenty Nine"),"28","Twenty Eight"),"27","Twenty Seven"),"26","Twenty Six"),"25","Twenty Five"),"24","Twenty Four"),"23","Twenty Three"),"22","Twenty Two"),"21","Twenty One"),"20","Twenty"),"19","Nineteen"),"18","Eighteen"),"17","Seventeen"),"16","Sixteen"),"15","Fifteen"),"14","Fourteen"),"13","Thirteen"),"12","Twelve"),"11","Eleven"),"10","Ten"),"9","Nine"),"8","Eight"),"7","Seven"),"6","Six"),"5","Five"),"4","Four"),"3","Three"),"2","Two"),"1","One")," - ",TEXT(INT(LEFT(MID(A1,FIND(".",A1)+1,3),FIND(".",MID(A1,FIND(".",A1)+1,3))-1)),"mmmm")," - ",SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+1,2),"20","Two Thousand"),"19","Nineteen Hundred")," ",IF(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1)="1",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,2),"19","Nineteen"),"18","Eighteen"),"17","Seventeen"),"16","Sixteen"),"15","Fifteen"),"14","Fourteen"),"13","Thirteen"),"12","Twelve"),"11","Eleven"),"10","Ten"),IF(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1)="0",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,2),"09","Nine"),"08","Eight"),"07","Seven"),"06","Six"),"05","Five"),"04","Four"),"03","Three"),"02","Two"),"01","One"),"00",""),CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1),"9","Ninety "),"8","Eighty "),"7","Seventy "),"6","Sixty "),"5","Fifty "),"4","Fourty "),"3","Thirty "),"2","Twenty "),"0",""),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+4,1),"0",""),"1","One"),"2","Two"),"3","Three"),"4","Four"),"5","Five"),"6","Six"),"7","Seven"),"8","Eight"),"9","Nine")))))

 

[mjbeam]

Oops, error in the Month section. This one will work:

=CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A1,FIND(".",A1)-1),"31","Thirty One"),"30","Thirty"),"29","Twenty Nine"),"28","Twenty Eight"),"27","Twenty Seven"),"26","Twenty Six"),"25","Twenty Five"),"24","Twenty Four"),"23","Twenty Three"),"22","Twenty Two"),"21","Twenty One"),"20","Twenty"),"19","Nineteen"),"18","Eighteen"),"17","Seventeen"),"16","Sixteen"),"15","Fifteen"),"14","Fourteen"),"13","Thirteen"),"12","Twelve"),"11","Eleven"),"10","Ten"),"9","Nine"),"8","Eight"),"7","Seven"),"6","Six"),"5","Five"),"4","Four"),"3","Three"),"2","Two"),"1","One")," - ",TEXT(DATE(2000,VALUE(LEFT(MID(A1,FIND(".",A1)+1,3),FIND(".",MID(A1,FIND(".",A1)+1,4))-1)),1),"mmmm")," - ",SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+1,2),"20","Two Thousand"),"19","Nineteen Hundred")," ",IF(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1)="1",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,2),"19","Nineteen"),"18","Eighteen"),"17","Seventeen"),"16","Sixteen"),"15","Fifteen"),"14","Fourteen"),"13","Thirteen"),"12","Twelve"),"11","Eleven"),"10","Ten"),IF(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1)="0",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,2),"09","Nine"),"08","Eight"),"07","Seven"),"06","Six"),"05","Five"),"04","Four"),"03","Three"),"02","Two"),"01","One"),"00",""),CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1),"9","Ninety "),"8","Eighty "),"7","Seventy "),"6","Sixty "),"5","Fifty "),"4","Fourty "),"3","Thirty "),"2","Twenty "),"0",""),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+4,1),"0",""),"1","One"),"2","Two"),"3","Three"),"4","Four"),"5","Five"),"6","Six"),"7","Seven"),"8","Eight"),"9","Nine")))))

 

[mjbeam]

The data you provided looked like it was in a text format, if it is actually in a date format, this function will work:

=CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(A1, "dd"),"31","Thirty One"),"30","Thirty"),"29","Twenty Nine"),"28","Twenty Eight"),"27","Twenty Seven"),"26","Twenty Six"),"25","Twenty Five"),"24","Twenty Four"),"23","Twenty Three"),"22","Twenty Two"),"21","Twenty One"),"20","Twenty"),"19","Nineteen"),"18","Eighteen"),"17","Seventeen"),"16","Sixteen"),"15","Fifteen"),"14","Fourteen"),"13","Thirteen"),"12","Twelve"),"11","Eleven"),"10","Ten"),"9","Nine"),"8","Eight"),"7","Seven"),"6","Six"),"5","Five"),"4","Four"),"3","Three"),"2","Two"),"1","One")," - ",TEXT(A1,"mmmm")," - ",SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+1,2),"20","Two Thousand"),"19","Nineteen Hundred")," ",IF(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1)="1",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,2),"19","Nineteen"),"18","Eighteen"),"17","Seventeen"),"16","Sixteen"),"15","Fifteen"),"14","Fourteen"),"13","Thirteen"),"12","Twelve"),"11","Eleven"),"10","Ten"),IF(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1)="0",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,2),"09","Nine"),"08","Eight"),"07","Seven"),"06","Six"),"05","Five"),"04","Four"),"03","Three"),"02","Two"),"01","One"),"00",""),CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1),"9","Ninety "),"8","Eighty "),"7","Seventy "),"6","Sixty "),"5","Fifty "),"4","Fourty "),"3","Thirty "),"2","Twenty "),"0",""),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+4,1),"0",""),"1","One"),"2","Two"),"3","Three"),"4","Four"),"5","Five"),"6","Six"),"7","Seven"),"8","Eight"),"9","Nine")))))

 

[Ganeszgk]

The data you provided looked like it was in a text format, if it is actually in a date format, this function will work:

=CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(A1, "dd"),"31","Thirty One"),"30","Thirty"),"29","Twenty Nine"),"28","Twenty Eight"),"27","Twenty Seven"),"26","Twenty Six"),"25","Twenty Five"),"24","Twenty Four"),"23","Twenty Three"),"22","Twenty Two"),"21","Twenty One"),"20","Twenty"),"19","Nineteen"),"18","Eighteen"),"17","Seventeen"),"16","Sixteen"),"15","Fifteen"),"14","Fourteen"),"13","Thirteen"),"12","Twelve"),"11","Eleven"),"10","Ten"),"9","Nine"),"8","Eight"),"7","Seven"),"6","Six"),"5","Five"),"4","Four"),"3","Three"),"2","Two"),"1","One")," - ",TEXT(A1,"mmmm")," - ",SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+1,2),"20","Two Thousand"),"19","Nineteen Hundred")," ",IF(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1)="1",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,2),"19","Nineteen"),"18","Eighteen"),"17","Seventeen"),"16","Sixteen"),"15","Fifteen"),"14","Fourteen"),"13","Thirteen"),"12","Twelve"),"11","Eleven"),"10","Ten"),IF(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1)="0",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,2),"09","Nine"),"08","Eight"),"07","Seven"),"06","Six"),"05","Five"),"04","Four"),"03","Three"),"02","Two"),"01","One"),"00",""),CONCATENATE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+3,1),"9","Ninety "),"8","Eighty "),"7","Seventy "),"6","Sixty "),"5","Fifty "),"4","Fourty "),"3","Thirty "),"2","Twenty "),"0",""),SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(MID(A1,FIND(".",A1)+1,9),FIND(".",MID(A1,FIND(".",A1)+1,9))+4,1),"0",""),"1","One"),"2","Two"),"3","Three"),"4","Four"),"5","Five"),"6","Six"),"7","Seven"),"8","Eight"),"9","Nine")))))

Respected sir,this is show error on this #Value!